DV list dropdown has no autocomplete feature.
You will have to use a ComboBox to achieve this but it does use VBA so may not
be suitable.
See Debra's Contextures site for how-to.
http://www.contextures.on.ca/xlDataVal10.html
Gord Dibben MS Excel MVP
On Fri, 14 Sep 2007 11:58:01 -0700, Rod from Corrections
wrote:
I have created a fairly simple worksheets that includes two columns with data
validation that requires users to select entries from a list of values.
Is there a way to set it up so that users can type the first few characters
in the entry instead of having to pull down and scroll through the list to
find the item?