Selecting from a drop down list

S

Scott W

I have a drop down list that has approx 120 choices. Is there a way to type
in a letter and have the highlight jump to the first name with that letter?

Example: I want to select the name "Jake"

Can I type in the letter "J" in the drop down list and have it jump to the
nearest name starting with "J"

Thank you for your help in advance!
 

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

drop down list 3
Data Validation drop-down width, with named range source (XL03 and 4
Dependent drop down dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
How do I change contents of a cell based on drop down list selecte 2
25#Data Validation 4
least prefix matching in a lookup list 4
Truncating data in drop down list 6

Top