Excel Filter Shortcut: Turn On and Open Filters

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn column filters on or off. To open the filter menu for a selected column, select its header cell and press Alt+Down Arrow.

These shortcuts do different things: the first adds or removes filter controls for a data range, while the second opens a menu so you can choose which records to display. Knowing the distinction makes it easier to filter a list without hunting through the ribbon.

What the Excel filter shortcuts do

Excel’s filtering feature, often called AutoFilter, places a drop-down button in each column header. The buttons let you show rows that meet chosen conditions, such as a particular department, a date range, or values above a threshold. Filtering hides rows that do not match; it does not delete them or rearrange the underlying data unless you also sort.

On Windows, Ctrl+Shift+L is the shortcut to apply or remove AutoFilter. It is a toggle: press it once to add filter buttons to the current data region, then press it again to remove them. It is not the command for opening one specific column’s menu.

To open a particular column’s menu from the keyboard, move to that column’s header cell and press Alt+Down Arrow. You can then navigate the menu with the keyboard. If you are already using the mouse, click the small arrow in the header instead. The menu’s choices depend on the type of values in that column.

Turn filters on with Ctrl+Shift+L

For an ordinary range, first click a cell inside the data, including a header row, and press Ctrl+Shift+L. Excel normally identifies the adjacent data region and adds drop-down arrows to its column headings. If the range has no header row, Excel may treat its first row as headings, so check the result before filtering. A clear, single header row helps Excel interpret the list correctly.

A simple sequence is:

  1. Make sure each column has a descriptive heading, such as Region, Order Date, or Amount.
  2. Click a cell within the list you want to filter.
  3. Press Ctrl+Shift+L.
  4. Check that the filter arrows appear beside the headings, then open the arrow for the column you want to use.

You can also use the ribbon: select a cell in the list and choose Data > Filter. That command applies or removes the filter controls, just like the toggle shortcut. If the list is a formatted Excel table, it generally already has filter buttons; its table settings can also control whether those buttons are displayed.

Open a column menu with Alt+Down Arrow

To open a filter drop-down using the keyboard, select the relevant heading cell and press Alt+Down Arrow. For example, if the active cell is the heading Region, the menu lets you choose which region values to show. Use the arrow keys and other available keyboard controls to move through the menu, then press Enter to apply a selection. Press Esc to close the menu without applying a new choice.

The exact controls inside the menu can vary with the filter type and Excel version, but common elements include a search box, a list of values with check boxes, and options for text, number, or date filters. In a values list, clearing Select All and checking only the desired entries is a quick way to show a small subset. The search box can help when a column contains many distinct items.

Be careful not to confuse the filter menu with a data-validation drop-down. Alt+Down Arrow can also open a validation list in a cell, so what appears depends on the selected cell. For a filter menu, focus a header that has a filter arrow. If the menu does not appear, check that filters are enabled and that the active cell is in the correct header.

Choose the right filter for your data

Excel offers different menu options according to the values in a column. A text column may offer text filters such as Contains or Begins With; a numeric column may offer number conditions such as Greater Than; and a date column may provide date groupings and date conditions. You can also select individual values from a list. These choices help answer specific questions without changing the source data.

For example, suppose a sales list has columns for Region, Salesperson, Order Date, and Amount. To display orders from the West region, open the Region menu, clear the other selected values, select West, and apply the filter. To narrow the result further, open Amount and choose a number condition for amounts greater than a chosen threshold. Excel combines filters across columns, so only rows meeting both conditions remain visible.

For dates, Excel may group values into years, quarters, and months when it recognizes them as real dates. If dates appear as individual text values or the options look unexpected, the cells may contain text rather than date serial values. Similarly, numeric filters require values Excel recognizes as numbers. Correcting inconsistent data types can make the expected filter choices available.

Filter menus, sorting, and hidden rows

Filtering and sorting are related but distinct. A filter hides rows that fail the selected condition; sorting changes the order of visible data. A column menu can offer both kinds of commands, so read the menu item before choosing it. If your goal is to see only a subset while preserving the existing order, use a filter condition rather than a sort command.

When a filter is active, Excel marks the relevant header with a filter indicator, and some rows are hidden from view. The row numbers may skip, which is normal. Those rows have not been removed. Clearing a filter restores the hidden records to view, although any sorting you applied remains in effect.

It is also possible to filter one column and then another. The visible result is the intersection of the conditions: a row must meet every active column filter to remain displayed. This is useful for progressively narrowing a large list, but it can make records seem missing if you forget that another column is still filtered.

Clear a filter without removing the controls

There are two different ways to reset filtering. To show all rows again while leaving the filter arrows in place, open the relevant column menu and choose Clear Filter From followed by the column name. You can also use the ribbon command Data > Clear to clear filter criteria for the filtered range. The exact menu wording can vary slightly by context.

To remove the filter buttons themselves, press Ctrl+Shift+L or choose Data > Filter. This is not the same as clearing the criteria: removing AutoFilter controls changes the interface, while clearing criteria restores rows but leaves the controls available. If several columns have conditions, clearing all filters is often faster than opening each menu separately.

Before concluding that rows have disappeared, check the column headers for active filter indicators and use the clear command. If you need to preserve a carefully chosen filter setup, avoid toggling AutoFilter off until you are sure you want to remove the controls.

Filtering an Excel table versus a plain range

Excel tables and ordinary ranges behave similarly when you use their filter menus, but they are not identical. A table created with Insert > Table or Home > Format as Table has structured formatting and typically includes filter arrows in its header row. When you add rows directly beneath a table, Excel can expand the table to include them, so the table’s filtering and formatting can extend to those records.

A plain range does not have the same table structure. When you turn on AutoFilter, Excel applies it to the data region it recognizes around the active cell. Blank rows or columns inside a list can interrupt that region, and adjacent unrelated data can sometimes make the intended boundary unclear. If the arrows appear over the wrong area, undo the setup if appropriate, select the complete intended range, and then choose Data > Filter.

In a table, filter buttons can be managed from the table tools when the table is selected. The table remains a table even if you hide its filter buttons. This distinction matters when someone expects Ctrl+Shift+L to remove table features: the shortcut concerns filter controls, not converting a table back into an ordinary range.

Common problems and fixes

If Ctrl+Shift+L seems to do nothing, start with these checks:

  • Confirm the active cell. Click inside the intended list. If the selection is elsewhere, Excel may apply filtering to a different region or not identify the range you meant.
  • Look for existing filter arrows. The shortcut toggles the controls, so pressing it when they are already visible may remove them rather than add them.
  • Check for a protected sheet. Worksheet protection can restrict sorting and filtering, depending on the protection settings. The sheet owner may need to allow those actions.
  • Inspect blank rows and columns. They can split a plain range into separate regions, preventing Excel from recognizing the full list.
  • Check whether the data has a header row. Headings should be in one row and should be distinct enough to identify each column.

If Alt+Down Arrow opens the wrong kind of list, or nothing opens, verify that the selected cell is the header with the filter button. A cell containing a data-validation list can respond to the same key combination. If keyboard focus is in a worksheet control or another interface element, click back into the worksheet and try again.

Windows, Mac, and Excel for the web

The main instructions above are for Excel for Microsoft 365 on Windows. In Excel for Mac, the shortcut to toggle filters is commonly Command+Shift+F, and Option+Down Arrow opens a column filter menu when the appropriate header is selected. Keyboard behavior can depend on the keyboard layout and macOS settings; the ribbon alternative is Data > Filter.

Excel for the web has a similar Data tab and filter controls, but browser and keyboard settings can affect shortcut behavior. If a key combination is intercepted or does not work, use Data > Filter to turn filtering on, then select a header’s filter arrow. This also provides a reliable route when using a device without a full desktop keyboard.

On a laptop, the arrow keys may share functions with media or navigation keys. If the keyboard does not send a plain Down Arrow, check whether the device requires the Fn key. This is a keyboard-specific issue rather than a different filter command in Excel.

Frequently Asked Questions

What is the shortcut to open a filter in Excel?
To show or hide filter arrows, press Ctrl+Shift+L on Windows. To open a particular column’s filter menu, select its header and press Alt+Down Arrow.

Does Ctrl+Shift+L open the filter drop-down?
No. It toggles AutoFilter controls for the current data region. Use Alt+Down Arrow on the relevant header cell to open that column’s menu.

How do I remove a filter but keep the arrows?
Open the filtered column’s menu and choose its clear-filter command, or use Data > Clear to clear criteria. Avoid toggling AutoFilter off if you want to keep the filter buttons visible.

What is the filter shortcut on a Mac?
In Excel for Mac, use Command+Shift+F to toggle filters and Option+Down Arrow to open the selected column’s menu. You can also use Data > Filter.

Why can’t I see all my rows after filtering?
An active condition in any filtered column can hide rows that do not match. Check the header indicators and clear the relevant filter criteria to display the full list again.

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.