Excel Filter Shortcut: How to Turn Filters On and Off

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for a data range or table. Once the filter arrows appear in the header row, open an arrow to show only rows matching the values or conditions you choose.

What the Excel filter shortcut does

Ctrl+Shift+L is a toggle: it adds filter controls when they are off and removes those controls when they are on. It does not delete rows or erase the criteria you used to narrow a list. A filter hides rows that do not match; the underlying data remains in the worksheet.

When filtering is active, Excel displays a drop-down arrow in each header cell. Use these menus to select specific values, sort a column, or create criteria such as “contains” or “is greater than.” A funnel symbol on a header indicates that a filter is applied to that column. The visible row numbers may skip, since matching rows are shown while other rows are hidden.

The shortcut is useful for quickly enabling or disabling filter controls, but it does not choose the filter criteria for you. For example, pressing it on a list of orders will not automatically show only one customer; you still open the Customer header menu and select that customer.

How to apply a filter step by step

For a simple rectangular list, click a cell within the data and press Ctrl+Shift+L. Excel usually identifies the surrounding range and adds arrows to the top row. If you prefer the ribbon, use Data > Filter. The same command turns the controls off when they are already enabled.

  1. Check that the list has one clear header row, with a different label in each column.
  2. Click any cell inside the list. You usually do not need to select the entire range.
  3. Press Ctrl+Shift+L, or choose Data > Filter.
  4. Open the arrow in the column you want to filter.
  5. Choose values or a filter condition, then confirm with OK if the menu offers that button.

For instance, a list with Date, Region, and Sales columns can be filtered by opening Region and selecting West. Excel hides rows for other regions, while the Date and Sales values on the remaining rows stay together. You can then add a second condition in the Sales column; filters applied to different columns work together, so only rows meeting both sets of criteria remain visible.

How filter menus work

A filter menu generally provides a searchable list of the distinct values in that column, along with options for sorting and condition-based filtering. Clear the check box for “Select All” and select only the entries you want to keep. The menu may look slightly different depending on the data type: text, dates, and numbers have different condition options.

Text filters can help find entries that begin with, end with, or contain a string. Number filters can show values above or below a threshold, between two numbers, or among the top items. Date filters commonly group dates by time periods such as month or year. The available choices depend on the values Excel recognizes in the column.

Search in the menu is handy for long lists, but it changes which values are checked only when you select or clear them and apply the menu. If a value you expect is missing, check for inconsistent entries: “North” and “North ” with a trailing space may be treated as separate values. Also check whether numbers or dates were imported as text, because Excel may then offer text-style options instead of the expected numeric or date filters.

Prepare your data for reliable filtering

Excel works best when each column has a single, descriptive header and each row represents one record, such as one order or one employee. Avoid blank rows or columns within the list, merged header cells, and multiple header rows. These can make it harder for Excel to identify the complete range or provide useful filter menus.

If you often add records, consider converting the range into an Excel table with Ctrl+T and confirming that the table has headers. A table includes filter arrows by default, expands as you add rows directly beneath it, and carries formatting and structured table behavior with it. You can still use the filter menus on a table; Ctrl+Shift+L is not necessary just to make a table’s existing arrows appear.

When a worksheet contains several separate blocks of data, click inside the specific block you want to filter before using the shortcut. If the detected range is wrong, undoing the command may not be the best fix: turn the filter off, remove gaps or clarify the intended range, select the full range, and apply Data > Filter again. Selecting the range first can help when adjacent content makes Excel’s automatic range detection ambiguous.

Filter, sort, clear, and remove are different

Filtering and sorting are related but distinct. A filter hides records that do not meet criteria; a sort rearranges the order of visible records. Both commands are available from a column’s drop-down menu, so it is easy to confuse them. Sorting by Sales from largest to smallest does not hide low sales; applying a number filter does.

  • Clear one column’s criteria: open that column’s menu and choose the option to clear its filter, if shown.
  • Clear all applied criteria: use Data > Sort & Filter > Clear to show the full list again while keeping filter arrows available.
  • Remove the filter controls: press Ctrl+Shift+L or choose Data > Filter. This switches AutoFilter off.

Clearing criteria is usually the right choice when you want to see every row again but expect to filter the list later. Toggling AutoFilter off removes the arrows, so you will need to switch it on again to work with the menus. Neither action is the same as deleting hidden rows.

Common shortcut and filter problems

If Ctrl+Shift+L appears to do nothing, first click a cell in the intended data range and check whether the worksheet is protected or whether the active cell is in a context where Excel cannot apply the command. Confirm that you are using desktop Excel on Windows and that another application or keyboard utility is not intercepting the keystroke. The ribbon route, Data > Filter, is a useful way to check whether the command itself is available.

If arrows appear only on some columns or the wrong rows are included, inspect the shape of the data. Blank rows can divide a list into separate regions; an empty header can lead to an unclear field; and a note or second table immediately beside the data can affect range detection. Turn the filter off, select the exact intended range, then use Data > Filter.

If filtering seems to hide records permanently, look at the row numbers and the filter icons. A filter hides nonmatching records rather than removing them. Choose Clear or restore the missing values in the column menu to show them again. If some records still do not appear, check for filters on other columns too: a second active filter can continue to exclude rows after you clear the first one.

Another common surprise is that new rows do not appear in a filtered range. A normal range may not automatically include data entered several rows away or separated by a blank line. Add records directly below the range or convert the list to a table so it can expand more predictably.

Windows, Mac, and Excel for the web

The Windows shortcut covered here is Ctrl+Shift+L. In Excel for Mac, the AutoFilter shortcut is commonly Command+Shift+F; keyboard mappings can vary with the Excel version, macOS settings, or a customized shortcut setup. If that combination does not work, use Data > Filter on the ribbon, which avoids uncertainty about the keyboard mapping.

Excel for the web runs in a browser, where browser or operating-system shortcuts can sometimes interfere with key combinations. If Ctrl+Shift+L does not toggle filtering in your browser, use Data > Filter in Excel’s ribbon. Filter menus and basic filtering work in the web app, although some options and interface details can differ from desktop Excel. On a laptop, you may also need to use the Fn key for a shortcut involving a function key, but Ctrl+Shift+L itself does not require one.

When to use a table or another filtering option

AutoFilter is a good fit for quickly exploring a flat list: show one department, inspect a date period, or find records above a sales threshold. For a list that grows over time, a table is often more convenient because its range can expand and its headers remain part of the table. Tables also make it easier to format records consistently, though they do not change the basic meaning of a filter.

For more complex analysis, a PivotTable can summarize and group data rather than merely hide rows. Slicers provide clickable filter controls for Excel tables and PivotTables, which can be easier to use in a shared report. These alternatives serve different purposes: use AutoFilter to inspect records, a PivotTable to aggregate them, and slicers when visual, reusable controls are useful. You do not need an add-in or a paid upgrade beyond an Excel edition that includes the relevant feature to use the basic filter shortcut.

Frequently Asked Questions

What is the shortcut key for filter in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off. On a Mac, try Command+Shift+F; Data > Filter is the ribbon alternative.

How do I filter a column in Excel using the keyboard?
Turn on the filter arrows with Ctrl+Shift+L, then use the relevant header’s drop-down menu to choose values or conditions. The shortcut enables the controls; it does not select the criteria automatically.

How do I remove a filter but keep the arrows?
Choose Data > Sort & Filter > Clear to clear applied filter criteria while leaving AutoFilter available. You can also clear criteria from an individual column’s menu.

Does Ctrl+Shift+L delete hidden rows?
No. Filtering hides rows that do not match the selected criteria; it does not delete them. Clear the filter criteria to display the rows again.

Why are the filter arrows missing?
Click inside the data and press Ctrl+Shift+L, or choose Data > Filter. If the list has blank rows, unclear headers, or protected-sheet restrictions, correct those issues or select the intended range before applying the filter.

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.