33

I have a drop-down menu created in an excel cell. Everytime I want to enter a value in that cell, after I navigate the focus to that cell using keyboard, I am not able to drop the drop-down menu using keyboard. I have to click the downward pointing arrow using mouse and then make a choice from the menu.

enter image description here

I want to know is there a keyboard short-cut to achieve the same? (I am quite sure there would be some short-cut that is there...)

Jay
  • 1,210
  • 9
  • 28
  • 48

1 Answers1

65

The keyboard shortcut is

Alt+Down Arrow

Then left arrow to select the top, and up/down again to select from within. Enter to choose.

Venkataraman R
  • 12,181
  • 2
  • 31
  • 58
Jüri Ruut
  • 2,500
  • 17
  • 20
  • Thanks a lot Jüri Ruut. I have been wasting a lot of time moving mouse around. – Jay Nov 15 '12 at 07:46
  • this is buggy on Mac... some cells will show the data validation list, for some cells it will show values from other cells on the same column... – Radu Simionescu Sep 28 '18 at 08:06