Movement of cursor within a drop down list

A

Anjana Anil

When we type a letter in the cell, the cursor should move to the word
starting with that letter in the drop down list. How this can be done?
 
L

L. Howard Kittle

If you are using a Data Valadation drop down try this.

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
 

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

How can I select an item in a drop down ? 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
excel drop down list 4
Excel Excel: How do I put a formula in a drop down list 11
Datagridview Cursor movement 1
Oversensitive touchpad on modern laptops 0
Drop down list quicker selection 5
cursor movement 4

Top