Excel Drop-Down Keyboard Shortcut: Open a List Quickly

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select a cell that has a drop-down list and press Alt+Down Arrow. Use the arrow keys to highlight an option, then press Enter to put it in the cell. On a Mac, use Option+Down Arrow. These shortcuts open a list that is already available; if the cell has no drop-down, you will need to create one or check that you selected the right cell.

What You’ll Need

  • An Excel workbook open in the desktop app, with a cell that contains a drop-down list, such as a Data Validation list. If you are trying to open a filter menu, you will need a range or table with filtering turned on.
  • A keyboard with arrow keys. On some compact keyboards, you may need to hold Fn to use the arrow-key functions.
  • Permission to edit the cell if you want to select and enter a new value. You can usually open a list in a protected sheet only if the sheet allows you to select that cell.

Step-by-Step

  1. Identify which kind of drop-down you mean. The most common kind is a Data Validation list inside a worksheet cell. It usually has a small arrow at the right edge of the selected cell when you click it. A filter menu is attached to a column heading, while a form control or combo box is a separate object placed on the sheet. The shortcut below is most useful for a cell list; the filter-menu option is covered in step 7.
  2. Select the cell that contains the list. Click the cell, or move to it with the arrow keys, Tab, or Enter. If you are navigating from another cell, confirm the selection border is around the cell with the list, not its label or the cell above it. For a range of list cells, select the particular cell whose options you want to see.
  3. Open the list with the keyboard. In Excel for Microsoft 365 on Windows, hold Alt and press the Down Arrow key. The list should appear below or above the cell, depending on the available room on screen. On a Mac, hold Option and press Down Arrow. On Mac keyboards, the Option key may be labeled ⌥.
  4. Move through the available choices. Press Up Arrow or Down Arrow to highlight an item. The highlighted choice is not necessarily committed to the cell yet. Read the visible options carefully, particularly when similar labels are next to one another or when the list is longer than the space shown.
  5. Choose an item. When the right option is highlighted, press Enter. Excel closes the list and enters that value in the selected cell. Check the cell afterward to make sure the expected value appeared. If the workbook uses formulas or dependent lists, changing a selection may also update other cells.
  6. Close the list without choosing a different item. Press Esc to dismiss the open list. This cancels the current navigation through the menu; it does not intentionally select the highlighted option. If you have already pressed Enter, however, the new value is in the cell. Use Ctrl+Z on Windows or Command+Z on Mac to undo that cell change when appropriate.
  7. Open a filter menu when that is what you need. If filtering is enabled, select a column-heading cell that has a filter arrow and press Alt+Down Arrow in Windows. Use the arrow keys and other available menu keys to navigate the filter options. A filter menu changes which rows are displayed; it does not enter a value into the heading cell. On Mac, keyboard behavior can depend on the Excel build and the selected object, so use the visible filter arrow if Option+Down Arrow does not open it.
  8. If there is no list yet, create a Data Validation list first. Select the target cell, then choose Data > Data Validation on the ribbon. In the dialog, set Allow to List, provide the list source, and make sure the in-cell drop-down option is enabled. Select OK, return to the cell, and try the shortcut. The source can be a range of cells or a typed list, depending on how the workbook is set up.

You do not have to click the small arrow to use a cell drop-down. The keyboard shortcut is especially useful when entering many records in sequence: move to the next input cell, open its list, choose an item, and continue. It is still worth checking each result, because arrow keys move the highlight and Enter is the action that confirms the choice.

Common Mistakes

  • Using the shortcut in the wrong cell. The shortcut opens a list associated with the active cell; it does not search the worksheet for a nearby list. Check the selection border and move to the correct cell before pressing the keys.
  • Expecting every arrow-shaped control to behave the same way. A Data Validation list, a filter menu, and a form control are different Excel features. A form-control combo box may need to be selected as an object first, and its keyboard behavior can differ. Use the relevant on-screen arrow if the cell shortcut is not appropriate.
  • Pressing only the Down Arrow. That moves the active cell or changes the highlighted list item; it does not usually open a closed Data Validation list. Press and hold Alt while pressing Down Arrow on Windows, or Option with Down Arrow on Mac.
  • Confusing a highlighted option with a saved selection. Moving through options is navigation. Press Enter to choose the highlighted item. Press Esc if you opened the menu accidentally and do not want to change the cell.
  • Assuming the list is missing because the shortcut failed. The cell may not have list validation, the in-cell drop-down may not be enabled, or the active worksheet may be protected. Check the cell’s setup before repeating the shortcut.

Tips

  • Use the mouse arrow as a quick check. If you are unsure whether a cell has a Data Validation list, select it and look for the small in-cell arrow. The arrow may only appear while that cell is selected. Its presence can confirm that you are working with a list rather than an ordinary cell.
  • Use the keyboard to keep your hands on the keys. After selecting an item with Enter, use Tab to move to the next cell in the row or Enter to move to the next row, depending on your workflow and Excel settings. Check the active cell after moving so you do not enter a choice in the wrong column.
  • Keep the source list understandable. If you maintain the workbook, put list choices in a clearly labeled range and keep the entries consistent. A clean source range makes it easier to verify what the drop-down should contain when an expected option is missing.
  • Remember that validation and filtering do different jobs. Choosing a Data Validation item changes a cell’s content. Choosing filter criteria hides or shows rows without changing the underlying values. Decide which result you need before opening a menu.
  • Use the ribbon when you cannot remember a shortcut. Clicking the cell’s visible arrow is a reliable alternative for a Data Validation list. For filters, use the arrow in the heading. The keyboard shortcut is a faster route, not a requirement for using either feature.

Troubleshooting

Nothing opens when you press the shortcut. First click or navigate to the cell itself and try again. Check that the cell has a Data Validation list with the in-cell drop-down enabled. To inspect it, select the cell and open Data > Data Validation. If the command is unavailable or the worksheet is protected, you may need permission to inspect or change the validation settings. On Windows, confirm you are holding Alt while pressing the down-arrow key; on Mac, use Option, not Command.

The shortcut moves the selection instead of opening a list. This often means the modifier key was not held, the wrong cell was active, or the cell does not contain an in-cell list. Try clicking the cell’s arrow to distinguish a shortcut problem from a missing list. If clicking the arrow also does nothing, inspect the validation settings or ask the workbook owner whether the cell is meant to have a list.

The list opens, but the option you need is missing. The available choices come from the list’s source. The source may be a range that does not include the new entry, or a typed list that has not been updated. If you have permission, open Data > Data Validation and inspect the source field. Update the source carefully, because changing validation settings can affect other cells if the rule is shared or copied across a range.

The menu opens in a different direction or is partly off-screen. Excel positions the list according to the room available near the selected cell, so it may open above the cell rather than below it. This is normal. Use the arrow keys to navigate the visible choices; if the sheet is zoomed in or the cell is near the edge of the window, scroll the worksheet or adjust the window to make the list easier to see.

The shortcut behaves differently in Excel for the web. The browser and operating system can affect which keys Excel receives. Try selecting the cell and using its visible arrow, or consult the keyboard-shortcut help for the browser version in use. The instructions above target the Excel desktop app for Microsoft 365 on Windows, with the Mac shortcut noted separately.

Frequently Asked Questions

What is the shortcut to open a drop-down in Excel?

For a cell with a Data Validation list in Excel for Windows, select the cell and press Alt+Down Arrow. On a Mac, use Option+Down Arrow.

How do I select an item without using the mouse?

Open the list with the shortcut, move through the options with Up Arrow or Down Arrow, and press Enter to choose the highlighted value. Press Esc to close the list without choosing a different item.

Why does Alt+Down Arrow not work in my cell?

The active cell may not have a Data Validation list, or its in-cell drop-down may be disabled. Select the intended cell and check Data > Data Validation. A protected sheet or a different kind of control can also affect what you can open.

Can I use this shortcut to open an Excel filter?

In Windows, select a filtered column heading and press Alt+Down Arrow to open its filter menu. This is separate from a Data Validation list inside a cell. On Mac, use the filter arrow if the keyboard shortcut does not work in your version.

Does opening the drop-down change the cell value?

No. Opening the list and moving the highlight do not by themselves commit a new choice. Press Enter to select an item; use Esc to dismiss the open list without selecting a different one.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.