Data Validation To Auto Fill

[kumara_faith]

Hi,

I have a data validation. When I click on the drop down arrow and I press "P", I would like the data validation to go straight to the first word with "P" in the list. Currently, I will have to scroll manually down the list. The list that I have is long. Is this possible ?

Appreciate help.

 

[JamesW]

I don't believe this is possible using Data Validation, this may be another way though:

http://www.ozgrid.com/Excel/autocomplete-validation.htm