Excel Validation List with Autocomplete in excel2007

[sheetal-maheshwari]

Hi,

How to create a validation list in excel that allows autocomplete features in excel 2007.

thanks
Sheetal

 

[grizz]

data validation does not support auto complete but you can create a drop down were if you type in the first letter it will give you a selection that only has that letter at start