Autocomplete searchable cells as you type

Copper 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

@DCDCDC 

 
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)

 
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

@DCDCDC 

In Excel Online it's like this

image.png

you just start typing

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

@DCDCDC 

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?