Menu
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...)
709
Alt+Down Arrow is the keyboard shortcut to open the drop down menu.
Use Alt + Down Arrow keys (Windows and Linux) or Option + Down Arrow keys (Mac) to open drop-down lists that do not have an Apply or Go button, and then use the Down Arrow, Up Arrow and Enter keys to select an item in the drop-down.
Ctrl+R in Excel and other spreadsheet programs In Microsoft Excel and other spreadsheet programs, pressing Ctrl + R fills the row cell(s) to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl + Shift + Right arrow to select additional ones.
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.
62
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
