Data Validation doesn't support autocomplete.

If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html


osaka78 wrote:
hi
i have created a validation list with more then 500 name, but when i try to
find a particual name i have to go through all of them . is it possblie to
write the first alphabitic letter in the list and the drow down list will
point to that particual name e.g if the name in the list is Mark S. Mark can
i write only Ma to find all Names start with Ma


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html