Forum Discussion
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 Channel since January 2022 (for example, see here https://www.youtube.com/watch?v=_GWHFT3rEIA. When will this feature will be available to the "Current Channel" ?
3 Replies
You may check comments to this official blog Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows - Microsoft Tech Community
As an alternative, you can try using a free Excel add-in.
Just google "Excel add-in called Search deList".
You can type some keywords to search the list, separated by a space, e.g "ma la". It gives you a unique, sorted & non-blank list.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.
I know I don't know anything (Socrates)
