Hi,
I have a Data Validation List which lists a bunch of text values.
First thing is Excel somehow doesn't autocomplete a cell, inspite of a
bunch of them already existing above it. That is ok. What i would
ideally like to provide to the end user is, that once they are inside
the list if they hit the button 'N' or '1', they should be able to go
to the first entry starting with that letter. The list is in sorted
order. I would be extremely appreciative if someone could suggest me
something.

Thanks,
Sameer