How to use keyboard to drop-down a menu in an excel cell?
cell, drop-down-menu, excel
Solution
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.
Problem
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. 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...)