Searchable drop down option
If I create a drop down list using Data Validation, I want to be able to search the drop down list by entering text without having to figure out some code using combo boxes. Google sheets has this feature - Excel should too.
Mayur Patel commented
@ Jon Wittwer
I wonder when Microsoft Excel Development Team will notice this.
I've found the solution. Maybe not perfect but for me it is enough. WPS Office has this functionality. I'm testing it now and I'm thinking for my usage it will be enough. And it cost less then MS Office.
Look at screenshot I've attached it exlpain everything.
+10 votes for this
I'm the same, I can't believe they haven't done this yet!
Why its not yet available. What is the issue ?
This is a MUST HAVE feature.
I cant believe that microsoft hasn't improved this feature in excel. I checked excel online version, it has this feature but to my surprise it only searches the list if first word found in list.
Say if you are searching for "Will Smith",
If you type "will" it will show you the match in dropdown.
If you type "smi" it will NOT show anything from the list.
I mean this is pathetic. Years of development and still we are looking for ease of entering data. This should be there from the very start.
I strongly suggest to update this feature without any delay, Give that feature via special updates so that every excel user can get benefit.
Search as you type should be there, No need to click that pathetic small arrow after typing few search letters. Also microsoft needs to work for the look of that dropdown arrow sign, it should be visible to old people.
Such small update can make millions of people happy. Dont waste a second for that. Just Do It !
I think this is a basic yet very important feature for data entry in excel
I completely agree
Burak Simsek commented
I agree. You put too much effort to create searchable drop down lists. I would be very thankful if it could be done by just using Data Validation.
I agree. It will be much bet to get this future not only in new versions of MSO, but issue update for MSO2007..MSO2010.
I agree - searchable drop down is a must have. Google docs is a fine example how should it work.
Jon Wittwer commented
A searchable or automatically filtered drop-down list would be a great feature for Excel to add!
One example would be a budget spreadsheet with a lot of budget categories. Autocomplete is nice, but it isn't sufficient.
Let's say you had the following list:
In Google Sheets, if you type "P" then your drop-down list automatically shortens to:
Google Sheets has not yet perfected this feature, in my opinion. Currently, Sheets only searches based on the beginning of the words, rather than a letter in the middle of a word. For example, if you type "y" you get no results even though "Mortgage Payment" contains a "y"
Although there are fancy tricks you can use to create a searchable list using dynamic ranges and the SEARCH function, these tricks require too much Excel expertise and are not a great solution for something simple like an account register.