Data Validation - Excel not suggesting values based on letters typed

%3CLINGO-SUB%20id%3D%22lingo-sub-1612089%22%20slang%3D%22en-US%22%3EData%20Validation%20-%20Excel%20not%20suggesting%20values%20based%20on%20letters%20typed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612089%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20list%20of%20values%20for%20a%20column%20of%20my%20spreadsheet%20and%20I%20want%20Excel%20to%20suggest%20a%20value%20based%20on%20the%20first%20letter%20or%20letters%20I%20type.%26nbsp%3B%20No%20matter%20what%20settings%20I%20try%2C%20nothing%20works.%26nbsp%3B%20I%20either%20get%20an%20error%20message%20or%20no%20suggestions%20pop%20up%20so%20I%20need%20to%20type%20out%20the%20whole%20word.%26nbsp%3B%20I%20know%20this%20is%20possible%20because%20I%20have%20done%20it%20before%2C%20so%20I%20don't%20understand%20why%20this%20is%20so%20complicated.%26nbsp%3B%20I%20chose%20LIST%20and%20entered%20the%20values%20separated%20by%20commas.%26nbsp%3B%20I%20tried%20every%20configuration%20of%20the%20options%20on%20the%20Settings%2C%20Input%20Message%20and%20Error%20Alert%20tabs%20and%20nothing%20seems%20to%20work.%26nbsp%3B%20Like%20I%20said%2C%20I%20KNOW%20this%20is%20possible%2C%20but%20I%20can't%20figure%20it%20out.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612114%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20-%20Excel%20not%20suggesting%20values%20based%20on%20letters%20typed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612114%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396761%22%20target%3D%22_blank%22%3E%40jdcma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EData%20validation%20doesn't%20provide%20this%20feature.%3C%2FP%3E%0A%3CP%3EOne%20option%20is%20to%20place%20the%20list%20of%20values%20immediately%20above%20the%20cell%20where%20you%20want%20to%20enter%20a%20value%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S3483.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214709i79A373534D1B2409%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22S3483.png%22%20alt%3D%22S3483.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20also%20possible%20to%20use%20a%20combo%20box%20in%20combination%20with%20some%20VBA%3A%20see%20%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2FxlDataVal10.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EData%20Validation%20Combo%20box%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I created a list of values for a column of my spreadsheet and I want Excel to suggest a value based on the first letter or letters I type.  No matter what settings I try, nothing works.  I either get an error message or no suggestions pop up so I need to type out the whole word.  I know this is possible because I have done it before, so I don't understand why this is so complicated.  I chose LIST and entered the values separated by commas.  I tried every configuration of the options on the Settings, Input Message and Error Alert tabs and nothing seems to work.  Like I said, I KNOW this is possible, but I can't figure it out. 

1 Reply
Highlighted

@jdcma 

Data validation doesn't provide this feature.

One option is to place the list of values immediately above the cell where you want to enter a value:

 

S3483.png

 

It's also possible to use a combo box in combination with some VBA: see Data Validation Combo box