Developer For Excel 2016 Autocomplete Drop Down

Download

To create your own drop-down list for the cell, do the following:

Click Kutools Drop-down List Searchable Drop-down List Enable Searchable Drop-down List. In the opening Kutools for Excel dialog box (this dialog only pops up when applying this feature at the first time), click the Yes button. Then in the Searchable Drop-down List dialog box, you need to configure as follows.

1. Create a column or a row of the items in theactive spreadsheet for the drop-down list.

Developer For Excel 2016 Autocomplete Drop Down

Developer For Excel 2016 Autocomplete Drop Down List

2. Select the cell that needs a drop-down list fordata validation (cell B2, in this example).

The List Search form contains a drop-down box that loads the selected cell's validation list. The drop-down box also functions as a search box. You can type a search in the box and the results will be narrowed down as you type. This is a Google-like search and the results will include any item that contains the search term. Besides the autocomplete function, you can also make the drop down list searchable for enhancing the working efficiency in finding proper values in the drop down list. For making drop down list searchable, try the method in this tutorial. Auto populate other cells when selecting values in Excel drop down list.

Developer For Excel 2016 Autocomplete Drop Down Box

3. On the Data tab, in the Data Toolsgroup, click Data Validation:

4. In the Data Validation dialog box, onthe Settings tab:

  • In the Allow drop-down list, select the List item.
  • In the Source box, specify the range that contains the drop-down list items(in this example, the range is E1:E8).
  • Check In-Cell Dropdown option to show the drop-down list. Otherwise, Excelvalidates your data entry but does not show the drop-down button to select itemsfrom the list.

5. Click OK.

Notes:

  • You can hide the range of values used in the Source box or create it onthe protected sheet that you can hide.
  • You can add the drop-down list to multiple cells by selecting the appropriatecells or copy/paste the cell with a list.
  • If the list is short, you can avoid Step 1. Instead, type your list items(separated by commas) in the Source box in the Data Validationdialog box:
  • If you plan to share your workbook with users of Excel 2007 or earlier, makesure that the list is on the same sheet as the drop-down list. Alternatively,you can use a named range.
Developer For Excel 2016 Autocomplete Drop Down

Developer For Excel 2016 Autocomplete Drop Down List

See also this tip in French:Création d’une liste déroulante dans une cellule.