I tried that way but an error message is poping up

I did the following:
First cliced the cell
Second I pressed the drop down down arrow and without pressing enter key I
typed A but nothing happening.


"The value you entered is not valid"
"The user has restricted values that can be entered into this cell"



"L. Howard Kittle" wrote:

Sort your validation list and at the beginning of the A's enter a single A,
do the same for the beginning of the B's and all the way through to the Z's.

Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.

Should take you to the O which is the top of the O list of selections.

HTH
Regards,
Howard

" VLOOKUP fORMULA" wrote in
message ...
Any body help please,

I have a drop down box using data validation, it is a big drop down menue,
is there any way to select the name using typing the first letter and the
drop down menu show as per to that letter type.

for example if i typed u, show all names starts from u

pls help.
thanks