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 do I create a drop down box within a drop down box? 1
drop down list 3
customize drop-down box 1
Displaying drop down list arrows 2
Formatted cell column in drop down list 1
Excel 2007 / right-click / pick from drop down list 1
Excel drop down list arrow has disappeared. 2
How to use keyboard to enter the drop down list? 2

Top