Not with DV list alone.
You have to ustilize a ComboBox in conjunction with the DV dropdown.
See Debra Dalgleish's site for how-to.
http://www.contextures.on.ca/xlDataVal10.html
Gord Dibben MS Excel MVP
On Wed, 6 Jan 2010 12:17:02 -0800, David
wrote:
Hi
I have a data validation drop down referencing a list of approx 300 names- I
have to choose about 20 names in 20 rows on a spreadsheet- is there a way of
typing in the first letter and the scrol bar goes down to that point like a
combo box?--
Thanks for your help