Excel Filter Drop-Down Shortcut: Open a Column Menu

In Excel for Microsoft 365 on Windows, select a cell in a filtered column and press Alt+Down Arrow to open that column’s filter drop-down menu. If the column does not have a filter yet, turn on filtering with Ctrl+Shift+L first, then use Alt+Down Arrow to open its menu.

What the shortcut does

Excel’s filter menu belongs to a column in a filtered list or table. It brings up the same menu you would see by clicking the small arrow beside that column’s header. From there, you can sort the column, choose which values to show, or use the available search and filter options.

The shortcut opens the menu for the active cell’s column; it does not turn filtering on or off. That distinction is useful: Alt+Down Arrow opens a menu, while Ctrl+Shift+L toggles AutoFilter for a selected data range. If filtering is not active, Alt+Down Arrow will not create a filter menu by itself.

For example, if a table has columns named Region, Product, and Sales, click a cell in the Region column and press Alt+Down Arrow. The Region menu opens, letting you show only selected regions or sort the regions. The other columns’ menus remain separate.

How to open a filter menu step by step

Click a cell in the column you want to filter. Choose a cell inside the filtered range or Excel table, rather than a cell elsewhere on the worksheet.
Press Alt+Down Arrow on a Windows keyboard. The menu for that column should appear.
Use the arrow keys to move through the menu. Depending on the data and menu, you may be able to type in a search field, move through value checkboxes, or select a sorting or filtering command.
Press Enter to choose an item or apply your selections. Press Esc to close the menu when you want to dismiss it.

When using value checkboxes, the exact menu contents depend on the column. A column of dates may offer date-specific filters; a column of numbers may offer number filters; and a text column may offer text filters. A list of distinct values may also appear, with a search box when appropriate.

Turn on filtering if the arrows are missing

If you cannot open a filter menu, first check that AutoFilter is active. Select a cell in your data range and press Ctrl+Shift+L. Excel adds filter arrows to the header row. You can also use the ribbon command Data > Filter. Pressing Ctrl+Shift+L again turns the filter controls off, so it is a toggle, not a shortcut for opening an individual menu.

Excel generally identifies the surrounding data as a range when you apply a filter. For a clearer result, make sure the list has one header row, with a distinct label for each column, and avoid blank rows or blank columns inside the data. If Excel selects only part of a list, select the intended range before choosing Data > Filter.

Excel tables normally include filter arrows in their header row. If you are working with a table and do not see them, confirm that the table has a header row and that its filter buttons have not been hidden. The Data > Filter command is also a practical way to check whether filtering is available for the selected data.

What you can do in the menu

The drop-down is more than a list of checkboxes. It combines sorting and filtering tools for the current column. Sorting changes the order of the visible records; filtering hides rows that do not meet the chosen criteria. Filtering does not delete the hidden rows, so clearing the filter can show them again.

Show selected values: In a Region column, select North and West to display records for those two regions while hiding other regions.
Search a long value list: Type part of a product or customer name into the menu’s search box, when available, to narrow the displayed choices.
Apply a rule: Use a text, number, or date filter when you need a condition such as begins with, greater than, or a particular date period.
Sort the column: Choose an ascending or descending sort command when you want to reorder the records rather than hide some of them.

Filters on different columns can be combined. For instance, filtering Region to North and Product to Desk shows rows that meet both column filters. Within a single column, selecting several listed values usually includes rows matching any of those selected values. This is why multiple checked values in one menu can work like an OR choice, while filters on separate columns narrow the result together.

Filter menus in tables and ordinary ranges

Excel supports filtering both structured tables and ordinary cell ranges. In a table, the filter arrows are part of the table’s header controls, and new rows added directly below the table are generally included as the table expands. A regular filtered range uses AutoFilter arrows on its header row but does not have all the other table features, such as structured references.

The keyboard action is useful in either case: move the active cell into the column whose menu you want, then press Alt+Down Arrow. If the selection is outside the table or filtered range, Excel has no corresponding column menu to open. If a list has several header rows, merged cells, or an inconsistent layout, Excel may not identify the intended header and data area as expected.

Filtering one column does not remove the filter controls from the others. You can open another column’s menu by selecting a cell in that column and repeating the shortcut. To restore all rows, open the relevant menu and clear its filter, or use the clear-filter command on the Data tab. Clearing a filter shows previously hidden records; turning AutoFilter off removes the drop-down controls.

Windows, Mac, and Excel for the web

This page’s primary shortcut is for Excel for Microsoft 365 on Windows: Alt+Down Arrow opens the current column’s AutoFilter menu. On Excel for Mac, the corresponding key combination is generally Option+Down Arrow. Mac keyboards label the Option key with ⌥; on some keyboards, you may need to use the relevant Fn or function-key setting for the arrow key to register as expected.

To enable or disable filtering, use Data > Filter on the ribbon on either platform. Keyboard shortcuts can differ by keyboard layout, operating-system settings, and Excel build, so the ribbon command is a dependable alternative if a key combination is intercepted or does not behave as expected.

Excel for the web runs inside a browser, where browser and operating-system shortcuts can affect which key combinations reach Excel. If Alt+Down Arrow does not open the menu there, click the filter arrow in the header or use the Data tab’s Filter command to apply or manage filters. The desktop shortcut should not be confused with browser shortcuts that may use similar keys for unrelated actions.

Common problems and quick fixes

Nothing happens: Check that filtering is turned on and that the active cell is inside the filtered column. If necessary, select the range and choose Data > Filter.
The wrong column menu opens: The shortcut follows the active cell’s column, not the mouse pointer. Click a cell in the intended column and try again.
The menu appears, but the expected values are absent: Another column may already be filtering out those rows. Clear other filters to see whether the records return.
Ctrl+Shift+L removes the arrows: That shortcut toggles AutoFilter. Press it again to restore the controls, or choose Data > Filter.
Some rows are not included: Look for blank rows or columns splitting the data, or select the full intended range before turning on the filter.

One common misconception is that filtering deletes records. It does not: a filter changes which rows are displayed. Avoid editing or copying data based on an assumption that hidden rows have been removed; they remain in the worksheet unless you explicitly delete them.

Frequently Asked Questions

What is the Excel shortcut to open a filter drop-down?
In Excel for Microsoft 365 on Windows, select a cell in the filtered column and press Alt+Down Arrow. On Mac, use Option+Down Arrow.

What shortcut turns Excel filters on or off?
On Windows, press Ctrl+Shift+L to toggle AutoFilter for the selected data. You can also choose Data > Filter on the ribbon. This toggles the filter controls; it does not open one column’s menu.

Can I open a filter menu without a mouse?
Yes. Move to a cell in the filtered column with the keyboard, then press Alt+Down Arrow on Windows or Option+Down Arrow on Mac. Use the arrow keys and Enter to work through the menu.

Why does Alt+Down Arrow not work in Excel?
Filtering may be off, the active cell may be outside the filtered range, or another application or keyboard setting may be intercepting the keys. Turn on filtering with Data > Filter and try again from a cell in the intended column.

Does filtering delete hidden rows?
No. Filtering hides rows that do not match the current criteria; it does not delete them. Clear the filter to display those records again.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.