Excel drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-2235601%22%20slang%3D%22en-US%22%3EExcel%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2235601%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20drop%20down%20list%20in%20an%20excel%20spreadsheet.%26nbsp%3B%20I%20have%20created%20the%20list%20of%20items%20for%20the%20drop%20down.%26nbsp%3B%20I%20did%20the%20data%20validation%20and%20assigned%20what%20data%20to%20use%20for%20the%20drop%20down.%26nbsp%3B%20I%20want%20to%20be%20able%20to%20start%20typing%20in%20that%20cell%20where%20the%20drop%20down%20is%20and%20have%20the%20drop%20down%20list%20show%20items%20based%20on%20what%20I%20begin%20typing.%20It%20won't%20do%20it%20right%20now.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20instance%3A%26nbsp%3B%20I%20start%20typing%20%22St%22%20and%20it%20shows%20me%20the%20items%20that%20begin%20with%20St%20to%20choose%20from.%3C%2FP%3E%3CP%3EI%20have%20tried%20going%20into%20%22FILE%2C%20Options%2C%20Advance%2C%20and%20enable%20autofill%20-%20but%20it's%20already%20enabled.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20great!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2235601%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a drop down list in an excel spreadsheet.  I have created the list of items for the drop down.  I did the data validation and assigned what data to use for the drop down.  I want to be able to start typing in that cell where the drop down is and have the drop down list show items based on what I begin typing. It won't do it right now.  

 

For instance:  I start typing "St" and it shows me the items that begin with St to choose from.

I have tried going into "FILE, Options, Advance, and enable autofill - but it's already enabled.

 

Any help would be great!

1 Reply

@SchellieMulready 

The Data Validation dropdown doesn't provide auto complete; it hasn't been updated since 1995 or so.

See Data Validation Combo box for an alternative.