Auto Complete for Data Validation in Excel

[Kobby ECS]

Hi Guys,

I wanted to know if there is any way that I can get my validated cells to suggest items in the validated lists based on texts typed in so far. All suggestions are welcome. Thanks

 

[Colin Legg]

Hi,

No, there isn't a way built-in to data validation lists so you can just do this "out of the box". There are various alternatives; for example:
http://www.contextures.com/xlDataVal10.html
http://www.excelforum.com/excel-2007-help/816240-autocomplete-in-drop-down-list-excel2007.html

 

[Nogslaw]

Not the best solution, but possibly the simplest:

1. Type or copy/paste your list of items in the rows directly above the validated cells.
2. Name the range (if desired)
3. Hide the rows that contain the target data
4. Use Data Validation > List, Refer to [your named range]
5. Toast your accomplishment