Drop Down List More

B

bettyh

I have a drop down list, I want it to select the choice when the first letter
is typed in. How can I do that?
I just need the dropdown to ensure there are no typos in the answer.
 
J

John Calder

One way is to 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


Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select drop down menu option using libre-calc macro 0
Double Drop-Down Validation in Excel 2007 1
Filtered drop down list 2
Drop-Down List 3
Linking drop down lists to another list 4
How to delete a drop down box in Excel 2007 1
drop down list 3
Drop down list ???? 1

Top