How to use keyboard to drop-down a menu in an excel cell?

excel drop-down-menu cell
Jay picture Jay · Nov 15, 2012 · Viewed 73.6k times · Source

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...)

Answer

Jüri Ruut picture Jüri Ruut · Nov 15, 2012

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.

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More