10

I'm working in Google Sheets and I've set up validation lists in a column. When I tab into that column the dropdown handle appears:

Selected cell with drop-down list handle

In order to access values from the list, I have to move my hand from the keyboard to the mouse and then use the mouse to select the appropriate value.

I looked at the spreadsheet docs, but the only thing I saw in there was how to create these cells.

Is there a keyboard shortcut to make a selection from the dropdown?

4 Answers 4

17

The new version of Google Sheets makes it very simple.

  1. Navigate to the cell containing the dropdown.
  2. Open the dropdown using one of the following keys:
    ENTERSPACEF2
  3. Navigate within the list using the up and down arrows.
  4. If you type any characters, the list will automatically filter to display only those items that begin with the same characters. For example, filtering by typing "y" returns "yes" and "yellow" but not "baby".
  5. Save your selection using one of the following keys:
    ENTERSPACEF2TAB
0
1

Just accidently ran into the solution. I hit F2 while I was on a drop down and it opened the drop down and I was able to scroll through my drop down and select the specific drop down item that I wanted.

1

In Google sheet F2 is actually more suitable to open the drop-down menu.

However, If you are aware of the list contents then go to the dropdown cell and simply type the first letter of the value that you wanted to select, you will be able to see all the values that start with the letter you type and then you can simply select the values by UP OR DOWN Arrows.

Plus it will filter the values and will make the menu list shorter if the menu list is too long.

1
  • You can improve your answer by explaining why you believe F2is more suitable.
    – Blindspots
    Nov 22, 2023 at 16:16
0

In Google sheets, when the cell with a validation is the active cell hit the space bar and your list will appear. Use the arrow keys for up and down, hit return on the entry needed or hit escape to move on.

Not the answer you're looking for? Browse other questions tagged or ask your own question.