Autocomplete searchable cells as you type

%3CLINGO-SUB%20id%3D%22lingo-sub-2215159%22%20slang%3D%22en-US%22%3EAutocomplete%20searchable%20cells%20as%20you%20type%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2215159%22%20slang%3D%22en-US%22%3EI%20want%2C%20as%20i%20type%2C%20for%20values%20to%20start%20showing%20based%20on%20a%20list%20of%20values%2C%20instead%20of%20having%20to%20type%20and%20then%20click%20on%20the%20dropdown%20arrow.%20How%20can%20i%20do%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2215159%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2215213%22%20slang%3D%22en-US%22%3EBetreff%3A%20Autocomplete%20searchable%20cells%20as%20you%20type%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2215213%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F999519%22%20target%3D%22_blank%22%3E%40DCDCDC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22pGxpHc%22%3E%3CDIV%20class%3D%22gb_8d%22%3E%3CDIV%20class%3D%22gb_Dc%20gb_Bc%20gb_Ic%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22dePhmb%22%3E%3CDIV%20class%3D%22eyKpYb%22%3E%3CDIV%20class%3D%22J0lOec%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EUnfortunately%2C%20I%20cannot%20understand%20what%20exactly%20you%20want%20to%20accomplish.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22J0lOec%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20an%20example%20file%20with%20different%20drop-down%20menu%20options.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22J0lOec%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20this%20is%20not%20what%20you%20are%20looking%20for%2C%20I%20would%20be%20happy%20to%20receive%20a%20detailed%20description%20of%20your%20project.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22J0lOec%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EA%20file%20(without%20sensitive%20data)%20would%20be%20an%20advantage.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWish%20you%20a%20nice%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CDIV%20class%3D%22%20B2mKhd%20%20eQGGme%20FYRjob%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
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

@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?