Now, turn on the design mode by clicking Developer > Design Mode. In the New Name dialog box, type DropDownList in the Name box, enter the formula below in the Refers to box, and then click the OK button.ġ1. Then drag its AutoFill Handle down to E9 to apply the same formula. Select cell E2, enter the formula below and press Enter. Then drag its AutoFill Handle down to the cell D9.Ĩ.

Select the cell D2, enter the formula below and press Enter. After finishing the above steps, you can now test: enter a letter C in the combo box, and then you can see that the formula cells that reference the cells containing the character C are filled with the number 1.ħ. If the Developer tab does not display on the ribbon, you can enable the Developer tab as follows.Ģ. You need to insert a Combo box instead of a data validation drop-down list in your worksheet.ġ. Suppose you have a list of country names in column A as shown in the screenshot below, and now you want to use them as the source data of the searchale drop-down lists, you can do as follows to get it done. In order to make the drop-down list searchable, you can follow the methods below step by step.Ĭreate a searchable drop down list in ExcelĮasily create a searchable drop down list with an amazing tool In addition to the autocomplete function, you can also make the drop down list searchable to improve the efficiency of finding the appropriate value in the drop down list.

We have previously introduced a method to auto-complete a drop-down list when the first letter is entered. How to create a searchable drop down list in Excel?įor a drop-down list with many values, finding a suitable value from the list is not an easy work.

Drop down menu in excel 2016