That's not possible in a standard data validation list. You can use a
combo box instead, as described he
http://www.contextures.com/xlDataVal11.html
Or add letters in the source list, as shown in Roger Govier's sample
file he
http://www.contextures.com/excelfiles.html
Under Data Validation, look for 'DV0046 - Add Headings for Navigation'
le clef wrote:
Hello all
I use a drop down list to allow users of a worksheet to select customer names.
Is it possible to open the list and press the first letter of the customer
name and be taken to the first occurance of that letter to save having to
scroll down the entire list ?
My thanks in anticipation
Nigel.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html