Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Movement of cursor within a drop down list
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Movement of cursor within a drop down list
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 "Anjana Anil" <Anjana wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CURSOR MOVEMENT | Excel Discussion (Misc queries) | |||
Cursor movement | Excel Discussion (Misc queries) | |||
Cursor Movement | Excel Discussion (Misc queries) | |||
Drop list movement | Excel Discussion (Misc queries) | |||
Movement of cursor | Excel Worksheet Functions |