Forum Discussion

Michelle99's avatar
Michelle99
Brass Contributor
Apr 10, 2022

Searchable dropdown in DESKTOP

Hello there. A searchable dropdown list is available in the browser version of excel, it looks like this:   I've seen numerous posts that the Desktop version of this feature has been in Beta...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Apr 10, 2022

Michelle99 

How to create a searchable drop down list in Excel?

For a drop-down list with many values, finding a suitable value from the list is not an easy work. We have previously introduced a method to auto-complete a drop-down list when the first letter is entered. 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. In order to make the drop-down list searchable, you can follow the methods below step by step.

Standard disclaimer: the site are none Microsoft site.

 

Additional Info:

Searchable Drop Down List in Excel

Standard disclaimer: the site are none Microsoft site.

Durchsuchbare DropDown-Liste mit Datenüberprüfung (ohne VBA)

 

Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)

Resources