Excel Filter Shortcut: How to Turn Filters On and Off

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off. Select a cell in your data first; Excel adds filter arrows to the header row, letting you show only rows that match the criteria you choose.

What the shortcut does

Ctrl+Shift+L is a toggle: pressing it once applies filter controls to a detected data range, and pressing it again removes those controls. It does not open a filter menu or choose which rows to display. After the arrows appear, use a header’s drop-down menu to filter by values, text, numbers, dates, or other available conditions.

Filtering hides rows that do not meet the selected criteria; it does not delete those rows or change the underlying values. For example, if a sales list has a Region column, filtering for West temporarily hides records for other regions. Clear the filter to show them again.

The shortcut is most predictable when the data is arranged as a single rectangular list: one header row, one record per row, and no entirely blank rows or columns splitting the list. If a workbook has several separate blocks of data, click inside the particular block you want to filter before using the shortcut.

How to apply a filter step by step

Arrange the records in columns and put a descriptive heading at the top of each column, such as Date, Product, or Amount.
Click any cell inside the list. You usually do not need to select every row or column.
Press Ctrl+Shift+L. Filter arrows should appear beside the headings.
Click the arrow for the column you want to examine, then choose values or a filter condition. Click OK if the menu presents that button.
To restore the full list, open that column’s menu and choose the option to clear its filter, or use the Data tab’s Clear command to clear filters across the range.

For a concrete example, imagine a table with columns named Date, Product, Region, and Sales. To see sales from one region, open the Region arrow and select that region. To narrow the result further to one product, also set a condition in the Product column. Excel combines filters on different columns, so the visible records must satisfy both conditions.

Filter menus and useful keyboard navigation

Once filter arrows are present, you can use the mouse or keyboard to work with a column menu. In Windows Excel, Alt+Down Arrow opens the drop-down menu for the selected cell when that cell is in a filtered heading. The menu provides the same kinds of choices as clicking the arrow. The exact available options depend on the data type and the Excel version.

Value lists are useful when you want an exact selection, such as showing only North and East. Text filters can find entries that begin with, contain, or do not contain specified text. Number filters can show values above or below a threshold, and date filters can group dates into periods such as months or years. These options operate on the values in the column; they do not rewrite the source data.

Within one column, selecting multiple values generally means show rows matching any selected value. Across separate columns, the filters work together: a row must meet the condition in each filtered column. This is why selecting two regions and then setting a sales threshold can show either selected region, but only where the sales condition is also met.

Windows, Mac, and Excel for the web

For Windows desktop Excel, the standard shortcut is Ctrl+Shift+L. On Mac, the commonly documented shortcut for applying or removing filters is Command+Shift+F. Keyboard behavior can vary with Excel releases, keyboard layouts, and system settings, so if the Mac combination does not respond, use the ribbon command instead.

In desktop Excel on either platform, the reliable ribbon route is Data > Filter. Clicking Filter applies or removes the filter controls for the selected list, much like the shortcut. The command is also useful if another application or a custom keyboard mapping has taken over a key combination.

Excel for the web has keyboard shortcuts too, but browser shortcuts and the active keyboard setting can affect what happens. If Ctrl+Shift+L is intercepted or behaves differently, use Data > Filter in the ribbon, or consult the Keyboard Shortcuts help available in Excel for the web. The web version’s interface can vary as Microsoft updates it, so the ribbon command is the clearest fallback.

Filtering a formatted Excel table

Excel tables, created with Insert > Table or the Ctrl+T shortcut on Windows, normally include filter arrows in their header row. If those arrows are already visible, there is no need to apply a second filter just to use them; open the relevant arrow and set the criteria. Tables also expand when you add records directly below them, which can make them convenient for lists that grow over time.

If the arrows on a table are missing, check the table settings rather than assuming the data is not filterable. Select a cell in the table and look for the table design options, including the Filter Button setting where available. A regular range and a formatted table do not behave identically in every situation, so use the visible table controls or Data > Filter if the shortcut does not produce the result you expected.

Filtering a table does not remove its records. New rows added to a table may inherit its formatting and become part of the table, but verify that a new record is included if you are working with a regular range or if a blank row separates it from the existing list.

Why the shortcut may not work

The active cell is outside the list. Click within the data block and try again. Excel uses the selected area to decide which range the command applies to.
The list has blank separators. A completely blank row or column can make Excel treat adjacent sections as separate ranges. Remove unintended separators or select the intended range before using Data > Filter.
The first row is not a clear header row. Add distinct column headings and avoid merged header cells. A clean header row helps Excel identify the fields for the filter arrows.
Filter arrows are already present. The shortcut toggles the feature; pressing it again may turn the arrows off rather than open a menu. Use the arrow itself to set criteria.
The worksheet is protected or the workbook is in a restricted state. Protection settings can limit changes. If you have permission, review the sheet’s protection settings or ask the workbook owner.
A shortcut conflict is involved. On Mac or in a browser, system or browser key handling may interfere. Use the ribbon command as a fallback.

One easy-to-miss issue is selecting only a portion of a list. If the range contains gaps or the selection is unusual, Excel may apply filtering to a different area than intended. Before filtering important data, confirm that the arrows appear on the correct header row and that all expected columns are included.

Filter versus sort, hide, and advanced filtering

Filtering and sorting are related but different. A filter changes which records are visible according to criteria; sorting changes the order of records. For example, filter a date column to show only March, then sort the visible records by Sales from largest to smallest. Sorting alone would reorder records without hiding the other months.

Manually hiding a row is also different. A filter applies a rule that Excel can display and clear through the column menus. A manually hidden row may remain hidden after a filter is cleared, which can make a list seem incomplete. If expected records do not return, check for manually hidden rows or columns as well as active filters.

For ordinary lists, AutoFilter is usually the quickest choice. Excel also provides an Advanced Filter command for more specialized workflows, such as filtering with a separate criteria range or copying matching records elsewhere. That command is not the same as pressing Ctrl+Shift+L, and most everyday tasks do not require it.

Good practices for dependable results

A well-structured source list makes filtering easier to understand and maintain. Use one row for headings and keep each field in its own column. For example, store city and state separately rather than combining them in one cell if you expect to filter by either one. Keep dates as actual date values and numbers as numeric values; text that merely looks like a date or number can limit the filter options Excel offers.

Before sharing a filtered workbook, consider whether readers might mistake hidden records for deleted records. You can clear filters before saving or add a note that the sheet is filtered. If you are copying results, remember that a normal copy operation may interact with hidden rows differently depending on how the range is selected; inspect the copied output before using it as a complete dataset.

Filters are useful for reviewing records, but they are not access controls. Someone with access to the workbook can clear a filter and reveal rows that are merely hidden by it. Do not use a filter to protect confidential information; remove sensitive data or use an appropriate permission-controlled sharing method.

Frequently Asked Questions

What is the filter shortcut in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to toggle AutoFilter on or off. On Mac, Command+Shift+F is the commonly documented equivalent; Data > Filter is a dependable alternative.

How do I open an Excel filter drop-down with the keyboard?
In Windows Excel, select a cell in a filtered column heading and press Alt+Down Arrow. This opens that heading’s filter menu, where you can work with the available criteria.

Does Ctrl+Shift+L delete rows that do not match?
No. Filtering hides nonmatching rows from view; it does not delete their contents. Clear the filter to display the records again.

How do I clear a filter without removing the arrows?
Open the filtered column’s drop-down and choose its clear-filter option, or use Data > Clear to clear filter criteria. This is different from toggling AutoFilter off, which removes the filter controls.

Why are filter arrows missing in Excel?
The list may not be selected, the range may have blank separators, or the worksheet may restrict changes. Click inside the intended list and use Data > Filter; for a table, also check whether its Filter Button setting is enabled.

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.