Keyboard Shortcut for Drop Down List

B

B Baggins

I have set Data Validation on a particular cell so that Jan, Feb, Mar etc
appear in a drop down list.

I need to be able to advise non mouse users how they can access this list.

I have tried "Shift" + "F10" then used the arrow keys to select, "Pick from
Drop Down List" but nothing appears in the list.

Does this method refer to a different list? If so, how do I set it?

Many thanks.
 
J

Joe_Germany

I have set Data Validation on a particular cell so that Jan, Feb, Mar etc
appear in a drop down list.

I need to be able to advise non mouse users how they can access this list.

I have tried "Shift" + "F10" then used the arrow keys to select, "Pick from
Drop Down List" but nothing appears in the list.

Does this method refer to a different list? If so, how do I set it?

Many thanks.
Click to expand...

<ALT + Down Arrow>

HTH
Joe
 

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 to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Accessibilty - how to open doc with keyboard? 0
drop down list 1
Formatted cell column in drop down list 1
drop down box code 2
drop down list and Locking certain cells 0

Top