Autocomplete searchable cells as you type

New Contributor
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


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.



I know I don't know anything (Socrates)

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


In Excel Online it's like this


you just start typing

Unfortunately, im not working online. The file needs to be able to perform this offline


Yes, I see, that's just an illustration. Perhaps one day will be on desktop version as well.

I am typing names in an excel column. Sometimes when I type a name that has already been entered above it completes the name for me. I understand this is an AutoComplete feature. But sometimes it does not work and sometimes it does. Suggestions?