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.
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.