Excel Filter Shortcut: Apply, Remove, and Use AutoFilter

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to apply AutoFilter to a data range—or press the same shortcut again to turn it off. Click a column’s filter arrow to choose which rows to show; on a Mac, use Command+Shift+F or choose Data > Filter.

What the Excel filter shortcut does

The shortcut switches AutoFilter controls on or off for the current data range. When you apply it, Excel adds a drop-down arrow to each detected column heading. Those arrows let you sort a column or filter the rows by values and conditions. The shortcut itself does not decide which records to show: you make that choice from a column’s drop-down menu.

For example, imagine a list with columns named Region, Product, and Sales. Pressing Ctrl+Shift+L adds filter arrows to the headings. Open the Region arrow and select West to show only rows whose Region value is West. The other records are hidden from view, not deleted. Clear the filter to see them again.

AutoFilter is most useful for inspecting or narrowing an existing list without changing its underlying records. It is different from sorting: sorting rearranges the visible records, while filtering temporarily hides records that do not meet the chosen criteria. You can sort and filter the same list using the column menus.

How to apply a filter on Windows

For a straightforward list, you usually do not need to select every cell. Click a cell inside the data and press Ctrl+Shift+L. Excel identifies the surrounding region and places filter arrows in its header row. Before doing this, check that the list has one clear header row and that each column has a heading.

  1. Click a cell within the list you want to filter. If Excel might detect the wrong area, select the full range, including its headings.
  2. Press Ctrl+Shift+L. Alternatively, use Data > Filter on the ribbon.
  3. Open the arrow beside the column you want to filter.
  4. Choose values or a filter condition, then confirm the selection if Excel presents an OK button.
  5. To show all rows for that column again, open its arrow and choose Clear Filter From [Column Name], or use the clear option in the menu.

For instance, with Order Date, Customer, and Status columns, you could open the Status menu and select Pending. To narrow the results further, open the Order Date menu and choose a date range. Filters from different columns combine: a row remains visible only if it meets the active criteria in each filtered column.

Using the filter arrows

A filter menu generally includes a search box and a checklist of values found in that column. Clear Select All, then check only the values you want to keep. This is convenient when a column contains a short list of categories, such as East, Central, and West. The search box helps when the list contains many distinct entries; search for a value, select the matching result, and apply the filter.

The menu also offers condition-based choices suited to the data type. A text column can offer options such as Begins With or Contains; a number column can offer comparisons such as Greater Than; and a date column can offer date-based choices. The precise menu options depend on the selected column and the values Excel recognizes in it.

  • Filter by selected values: Keep particular labels, names, or categories and hide the rest.
  • Filter by condition: Show entries meeting a rule, such as numbers greater than a threshold or text containing a word.
  • Use multiple columns: Apply a separate criterion to each relevant heading to narrow the visible records step by step.
  • Clear one filter: Use that column’s menu to remove its criterion while leaving other column filters in place.

Filtered rows are hidden from the worksheet view, but filtering does not erase their contents. If a count or calculation seems to reflect fewer records than expected, check the filter arrows for active criteria. Some worksheet functions and summaries treat hidden rows differently, so the result depends on the function or feature being used.

Apply filters to an Excel table

Excel tables are a practical choice for lists that will grow over time. To make one, select a cell in the data and choose Insert > Table, then confirm whether the table has headers. Tables normally display filter arrows in their header row automatically, so you do not need the shortcut just to add those controls. You can still use the filter menus in the same way.

Tables also make the data range easier to manage. When you type or paste data directly below a table, Excel can expand the table to include it, keeping the table’s structure and features together. With an ordinary range, newly added rows may fall outside the existing AutoFilter range; if so, the new records will not appear in its filtering results until you expand or reapply the filter range.

Use a regular filtered range when you want a simple filter on a fixed block of data. Consider a table when the list is updated regularly, when you want structured column names in formulas, or when you want table formatting and automatic range expansion. Creating a table is not required to use Ctrl+Shift+L.

Mac and Excel for the web

In Excel for Mac, Command+Shift+F is the commonly documented shortcut for applying or removing AutoFilter. If that combination is unavailable on your keyboard or behaves differently in your Excel release, use Data > Filter; the ribbon command is the straightforward alternative. The main filtering workflow—opening a column arrow and choosing values or conditions—is similar on Windows and Mac.

In Excel for the web, use the Data tab’s Filter command if a keyboard shortcut is intercepted by your browser or does not match your keyboard layout. The ribbon is also a useful fallback on Windows and Mac: shortcuts can vary with platform settings, keyboard layout, and the version of Excel in use. After applying the command, look for arrows in the headings to confirm that the range was recognized.

Common filter problems and fixes

If the shortcut appears to do nothing, first check that Excel has focus and that the selected cell is in the data. Then try Data > Filter. If arrows appear in only part of the list, or a newly added record is missing, inspect the range: blank rows or columns can split a list into separate regions, and the filter may cover only one of them.

  • No arrows appear: Confirm that the selection is inside a normal range or table, then use Data > Filter. Check whether worksheet protection or a restricted editing state prevents changes.
  • The heading row is treated as data: Make sure the range includes the actual headings and that Excel recognizes them as the header row. A clear, single header row helps Excel identify the list correctly.
  • Some records are missing from the filter range: Look for blank rows or columns that divide the list, or select the full intended range before applying Filter. For an existing filter, expand the range as needed.
  • A value you expect is not listed: Check whether another filter is already active, and inspect the source cells for inconsistent spelling, spaces, or different data types.
  • The sheet looks incomplete: Check the filter icons for active criteria. Clear the relevant filter to restore the rows it hid; filtering hides records rather than deleting them.

A particularly common source of confusion is inconsistent data. A column that looks like it contains dates may include text entries that only resemble dates. Likewise, “West” and “West ” with a trailing space may be treated as distinct values. If a checklist seems unexpectedly fragmented, review the source data and make entries consistent before relying on the filter.

Filter shortcut compared with sorting and Find

AutoFilter is not the same as the Find command. Find locates text or values in a worksheet; a filter keeps matching records visible together and hides the rest of the list. If you need to review every matching row or compare records across several columns, filtering is often more useful than repeatedly searching.

Filtering is also separate from sorting, although both appear in the column menus. A sort changes the order of records—for example, putting sales from largest to smallest. A filter limits which records are displayed—for example, showing only sales above a chosen amount. You can use both, but remember that sorting a list changes its row order. Keep complete records together when sorting so that values from different columns do not become mismatched.

For a quick visual scan, the shortcut is usually faster than opening the ribbon. For a new or expanding dataset, a table may be easier to maintain. For a one-time filter or when shortcuts are inconvenient, Data > Filter provides the same core AutoFilter command.

Frequently Asked Questions

What is the shortcut to apply a filter in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L. On Mac, use Command+Shift+F, or choose Data > Filter if the shortcut is unavailable.

Does Ctrl+Shift+L turn the filter off too?
Yes. It toggles AutoFilter on or off for the selected data range. To remove just one criterion while keeping the filter arrows and other criteria, clear that column’s filter from its drop-down menu instead.

How do I clear a filter but keep the arrows?
Open the filtered column’s drop-down and choose Clear Filter From [Column Name]. This restores the rows hidden by that criterion while leaving AutoFilter available. To remove the arrows, use Data > Filter or the toggle shortcut.

Why does the filter not include my newest rows?
The new rows may be outside the range AutoFilter originally detected, especially if a blank row separates them from the list. Expand the filtered range to include them, or convert the list to an Excel table so additions directly below it can be included more naturally.

Can I filter by more than one column?
Yes. Choose a criterion from one column, then choose another from a different column. Excel shows rows that satisfy the active criteria together, so each additional filter narrows the visible results.

Does filtering delete hidden rows?
No. AutoFilter hides rows that do not meet the chosen criteria; it does not delete their data. Clear the filter to show those records 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.