Forum Discussion
Autocomplete searchable cells as you type
I want, as i type, for values to start showing based on a list of values, instead of having to type and then click on the dropdown arrow. How can i do this?
7 Replies
That works in Excel Online. Workaround for desktop version could be Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) - Xelplus - Leila Gharani
- You understood what my issue is, however, that wont help the issue because i would like to not have to click the button (arrow) to show the possible values, i want to as i type, automatically values would start showing instead of having to click the button
- Unfortunately, I cannot understand what exactly you want to accomplish.Here is an example file with different drop-down menu options.If this is not what you are looking for, I would be happy to receive a detailed description of your project.A file (without sensitive data) would be an advantage.
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
