If you cannot find the Developer tab in the ribbon, please enable the Developer tab as follows.Ģ. For creating searchable drop down list, please do as follows.ġ.
This method requires Combo box instead of data validation drop down list. For making drop down list searchable, please do as below tutorial shows step by step.Ĭreate a searchable drop down list in ExcelĮasily create a searchable drop down list with an amazing toolįor example, the source data you need for the drop down list is in range A2:A9. 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.
Previously we have introduced a method of auto completing drop down list when enter the first letter into the drop down box. How to create a searchable drop down list in Excel?įor a drop down list with numerous values, finding a proper one is not an easy work.
