Excel Filter Drop-Down Shortcut: Windows and Mac

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select a cell in the filtered column’s header and press Alt+Down Arrow to open its filter drop-down. To turn filter arrows on or off for a data range, press Ctrl+Shift+L. These shortcuts do different things: one opens a menu; the other toggles filtering.

Opening a Filter Drop-Down Versus Turning Filters On

The phrase “filter shortcut” can refer to two actions. If filter arrows are already visible and you want to choose a value, condition, or sort order for one column, use Alt+Down Arrow while the relevant header cell is selected. Excel opens that column’s menu, where you can move through the options with the keyboard.

If the arrows are not visible, Ctrl+Shift+L turns AutoFilter on for the current data range and adds drop-down arrows to its headers. Pressing the same shortcut again turns the filter off. It does not open a menu, and it does not necessarily clear the choices you previously made. If you only need to filter one column, turn filtering on first, then select that column’s header and open its menu.

On Excel for Mac, Option+Down Arrow is the corresponding key combination for opening a filter menu. The usual toggle shortcut is Command+Shift+F. Keyboard mappings can vary with Excel releases, keyboard layouts, and system settings, so the menu path Data > Filter is a useful alternative if a shortcut behaves differently on your Mac.

How to Open a Filter Menu Step by Step

Use this sequence when you want to filter an ordinary range of data in Windows Excel:

  1. Check that your data has a single header row, with a label for each column.
  2. Click a cell in the header row of the column you want to filter. For example, click the header named Region if you want to show only a particular region.
  3. If the header does not have a drop-down arrow, press Ctrl+Shift+L to turn on filtering.
  4. With the header cell still selected, press Alt+Down Arrow. The column’s filter menu opens.
  5. Use the arrow keys to move through menu choices. Press Space to select or clear a check box, and press Enter to apply the selection. Depending on the menu and the item selected, Enter may open a submenu or confirm a command.

In a list of check-box values, clearing Select All and selecting only the values you want is often the quickest way to narrow the results. For example, in a sales list with a Region column, you can leave North and West checked and clear the other regions. Pressing Enter applies the filter, while the worksheet displays only rows matching the selection. The hidden rows are not deleted; removing the filter makes them visible again.

What You Can Do Inside the Drop-Down

A filter menu contains options that depend on the kind of data in the column. A column of text may offer text filters such as Begins With or Contains; a column of dates may offer date-based choices; and a column of numbers can offer number comparisons. The menu also includes a checklist of distinct values currently available in that column. The exact choices may change if another column is already filtered, because Excel then presents values from the remaining visible records.

Sorting and filtering are related but not identical. A sort rearranges the order of rows, such as putting dates from newest to oldest. A filter temporarily hides rows that do not meet the chosen criteria. Both types of controls are accessible from the header’s drop-down, but selecting a sort command does not limit which records are shown.

When a filter is active, Excel indicates it on the column’s header arrow, typically by changing the icon to a filter symbol. If rows seem to be missing, inspect the filtered columns before assuming data was erased. The menu’s Clear Filter command for that column restores its records without removing filters on other columns.

Using Shortcuts with Excel Tables

Excel tables have filter arrows built into their header row by default. If you have converted a range into a table using Insert > Table or Ctrl+T, you can usually select a table header and press Alt+Down Arrow to open its menu without first enabling AutoFilter. If the arrows were deliberately turned off, use the table’s settings or the Data tab to restore them.

Tables are often more convenient for data that grows over time. When you add a row directly beneath a table, Excel generally expands the table and includes the new row in its sorting and filtering. A plain range does not always expand automatically, so records appended below it may be left outside the filter area. If Ctrl+Shift+L seems to affect only part of your list, check whether the range includes every column and row, or consider converting it to a table.

Keep the header row distinct: avoid blank header cells, merged headings, and extra title rows inside the data. Excel needs a consistent row of field names to identify the columns correctly. If the worksheet has a title above the data, select a cell within the actual data range before turning on filtering, and confirm that Excel has recognized the right header row.

Useful Related Filter Shortcuts

Alt+Down Arrow is not exclusive to AutoFilter. In a cell with a data-validation list, it can also open that list. Context matters: if the selected cell is a column header in a filtered range, it opens the filter menu; if the selected cell has a validation list, it opens the list of allowed entries. This is a common reason the same key combination appears to do something different in another part of a workbook.

Other useful Windows shortcuts include:

  • Ctrl+Shift+L: Turn AutoFilter on or off for the current range.
  • Alt+Down Arrow: Open the selected header’s filter menu, or a validation list where one is present.
  • Esc: Close an open menu without applying a new choice.
  • Ctrl+Z: Undo many worksheet changes, though it is not a dependable way to reverse every filter or menu action.

Excel for Mac commonly uses Command+Shift+F to toggle filters and Option+Down Arrow to open the menu. On Excel for the web, shortcuts can depend on the browser and operating system, and some combinations may be intercepted by the browser. If a key combination fails, use the ribbon’s Data tab and choose Filter, or use the accessible controls shown in the column header.

Common Problems and Fixes

If Alt+Down Arrow does nothing, first confirm that the active cell is in the header row of a range with filtering enabled. Selecting a data cell several rows below the header is not the most reliable way to target a particular column’s filter menu. Click the header itself, check for its drop-down arrow, and try again. If there is no arrow, press Ctrl+Shift+L or choose Data > Filter.

If the shortcut opens a validation list instead, the selected cell probably has a drop-down created through Data Validation. Select the actual column header instead. If it opens a different application or system feature, check whether another program, a laptop function-key setting, or a custom keyboard mapping is capturing the keystroke.

If Excel filters the wrong range, look for blank rows or columns that split the data, or select the complete dataset before enabling filtering. A single empty row inside a list can make Excel treat records below it as a separate block. Also check that each column has a heading and that the heading row is included. When the data is already a table, verify that the table boundaries include the records you expect.

If the checklist does not show a value you expect, another column’s active filter may have hidden every row containing that value. Clear that other filter and reopen the menu. Also note that Excel’s checklist can behave differently when the list is very large or contains many distinct values; a Text Filters or Number Filters condition may be easier than scrolling through a long checklist.

When to Use the Ribbon Instead

The keyboard is fastest when you already know the selected cell and the action you want. The ribbon is often clearer when setting up filtering for the first time, diagnosing a range problem, or working on a computer where shortcuts differ. On Windows, go to Data > Filter to toggle the filter controls. You can also use the header arrow itself with a mouse or trackpad.

For one-off filtering, AutoFilter is usually enough. For a reusable report, a table or PivotTable may be more suitable: a table preserves row-level records and offers column filters, while a PivotTable summarizes data and has its own field filters and controls. These features serve different purposes; a PivotTable is not simply another way to open the same AutoFilter menu.

Frequently Asked Questions

What is the shortcut to open the filter drop-down in Excel?
In Windows Excel, select the column header and press Alt+Down Arrow. The filter must already be enabled for that range.

What is Ctrl+Shift+L used for in Excel?
It turns AutoFilter on or off for the current data range. It adds or removes the header arrows; it does not open an individual column’s menu.

What is the Mac shortcut for an Excel filter drop-down?
Use Option+Down Arrow with the relevant filter header selected. Command+Shift+F is commonly used to toggle filtering on a Mac.

Can I open an Excel filter menu without a mouse?
Yes. Select the header cell using the arrow keys or other navigation shortcuts, then press Alt+Down Arrow on Windows or Option+Down Arrow on Mac. Navigate the menu with the keyboard.

Why does Alt+Down Arrow open a different list?
The shortcut can open a data-validation list when the selected cell has one. Select the filtered column’s header instead to open its AutoFilter menu.

Does clearing a filter delete rows?
No. Clearing a filter makes matching hidden rows visible again; it does not delete them. A filter changes which records are displayed, not the underlying data.

Related

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.