Excel Filter Shortcut: Turn Filters On and Off

Formulas & functions · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select a cell in your data and press Ctrl+Shift+L to turn filter arrows on or off. In Excel for Mac, the usual shortcut is Command+Shift+F; you can also use the ribbon command Data > Filter.

The shortcut at a glance

AutoFilter adds a drop-down arrow to each header in a selected data range or Excel table. Those arrows let you show records that match conditions you choose, such as one region, a date period, or values above a threshold. The shortcut is a toggle: press it once to apply or enable the filter controls, and press it again to turn them off.

For the shortcut to act on the data you intend, first click a cell inside the list or table. If the data is a plain range and Excel does not identify its boundaries correctly, select the entire range, including its header row, before using the shortcut. You do not need to select every cell when the data is a clearly organized, contiguous block.

  • Windows: Ctrl+Shift+L
  • Mac: Command+Shift+F in current Excel for Mac; shortcut behavior can vary with keyboard settings or Excel version.
  • Ribbon alternative: Data > Filter.

How to apply a filter step by step

  1. Arrange the data in columns, with one descriptive heading at the top of each column, such as Date, City, or Amount.
  2. Click a cell within the data. If Excel might misread the boundary, select the complete block, including the headings.
  3. Press Ctrl+Shift+L on Windows, or choose Data > Filter. On Mac, use Command+Shift+F or the same Data tab command.
  4. Look for a drop-down arrow beside each heading. Open the arrow for the field you want to filter.
  5. Choose a value, search for a value, or select an available condition. Confirm the choice if the menu presents an OK button.

For example, imagine a list with the headings Region, Salesperson, and Order Date. Open Region and select West to display only West records. Then open Order Date and set a date condition to narrow those results further. A second filter works together with the first: a row must meet both conditions to remain visible.

What the shortcut changes

The shortcut turns the filter controls on or off; it does not open a filter menu or choose a criterion for you. Once the arrows appear, click the arrow in the relevant header to control which records are displayed. A funnel symbol on a header usually indicates that a filter is active for that column. A plain arrow indicates the control is available, but does not by itself mean the data is filtered.

Filtering hides rows that do not match your criteria rather than deleting them. The row numbers may skip, which is a useful sign that some records are hidden. Removing a filter makes those rows visible again. This distinction matters before copying, printing, or reporting: a filtered sheet can still contain records that are not currently shown.

Filtering is also different from sorting. A filter limits which rows are visible; sorting changes the order of rows. You can use both at once, for example displaying only West-region orders and then sorting the visible results by date. Neither action, by itself, edits the underlying values in the records.

Choosing filter conditions

The filter menu adapts to the type of data in a column. Text columns commonly offer a checklist of distinct entries, a search box, and text conditions. Number columns offer numeric conditions, while date columns provide date-oriented choices. The exact menu options depend on the data and the Excel version.

For a straightforward selection, clear Select All and check only the entries you want. For a long list, type part of an entry into the menu search box rather than scrolling through every item. Conditions are useful when you want a rule instead of a fixed list: for example, a number greater than 500 or text that begins with North.

Check for inconsistent data before relying on the result. Values that look alike may differ because of extra spaces, spelling, or data type. For instance, a date stored as text may not behave like a real Excel date in date filters. If a value is missing from the checklist, inspect the source cells and remove or correct inconsistent entries.

Filtering an Excel table versus a plain range

Excel tables and ordinary ranges both support filter arrows, but tables are designed to grow with ongoing data. To create a table, select the data and choose Insert > Table, then confirm whether the range has headers. Tables normally show filter buttons in their heading row, and new rows added directly below a table are generally included as part of it.

A plain range can be filtered without converting it to a table. This may suit a one-off list or a layout that should remain unchanged. However, Excel needs to identify the range correctly. A completely blank row or column inside the data can make it treat part of the list as separate, so select the full intended block when necessary. Use one header row and avoid merged cells in the data area for more predictable results.

If a table already has filter arrows, pressing the toggle may change whether its filter buttons are displayed. You can also control the buttons from the table settings: select a cell in the table, open Table Design, and use the Filter Button option in Table Style Options. Table behavior can differ from a plain range, so check the heading row after toggling.

Turning filters off, clearing criteria, and showing all rows

These are related actions, but they are not interchangeable. To remove the filter controls from a range, use Ctrl+Shift+L on Windows or Data > Filter. If the goal is simply to see every record while keeping the arrows available, clear the filter criteria instead. Open the filtered column’s menu and choose the command to clear the filter, or use the clear-filter option available on the Data tab.

Clearing one column’s criteria leaves other columns’ filters in place. That is useful when a report has several conditions and you want to broaden only one part of the results. To restore the whole list, clear the active filters in each relevant column, or use Excel’s command to clear filters for the current range. Turning the arrows off is a less precise way to manage criteria because it removes the controls and may also restore hidden rows.

Before toggling filters off in a workbook that someone else prepared, note any active criteria if you may need to recreate them. If you only need a temporary all-records view, clear the criteria rather than disabling the feature. That preserves the convenient drop-downs for later filtering.

Common problems and fixes

  • No arrows appear: Click inside the data and try again. If necessary, select the entire range, including its header row, then choose Data > Filter. Also check whether the sheet is protected or the data layout includes blank breaks.
  • The shortcut does something unexpected: Confirm that Excel, rather than another application or a keyboard utility, has focus. On Windows, make sure you are pressing Ctrl, Shift, and L together. If the shortcut is unavailable, use Data > Filter.
  • Some records seem missing: Look for an active funnel icon and clear the relevant criterion. Also inspect other columns; multiple filters combine, so a row must pass all of them to appear.
  • Excel filters only part of the list: Select the full data block manually and apply the filter again. Check for blank rows or columns that divide the range, and make sure the headings are in one continuous top row.
  • Headings appear as data: The selected range may not include the intended header row, or Excel may have interpreted the first row incorrectly. Reapply the filter to the range with the headings included and verify the header option if prompted when creating a table.

It is also worth checking whether the worksheet is protected. Protection settings can restrict changes to sorting and filtering, even when the arrows are visible. If you have permission to edit the sheet, review the protection options or ask the workbook owner to allow filtering. Do not remove protection if you are not authorized to change the file.

Windows, Mac, and Excel for the web

This article gives the Windows Microsoft 365 shortcut first: Ctrl+Shift+L. On current Excel for Mac, Command+Shift+F is commonly used to apply or remove filters. Some Mac keyboard setups or versions may handle shortcuts differently, so the dependable menu route is Data > Filter. The ribbon command is also a useful fallback if a shortcut is intercepted by system settings.

Excel for the web has a browser-based interface and may handle keyboard combinations differently depending on the browser and operating system. If a shortcut does not work there, select the data and use the Filter command on the Data tab. Avoid assuming that a shortcut documented for Windows desktop Excel will behave identically in a browser.

Useful related keyboard actions

After applying filters, the most useful companion shortcut on Windows is Alt+Down Arrow when the active cell is in a filtered header. It opens that column’s filter menu, allowing you to move through choices without reaching for the mouse. The available navigation keys can depend on the menu state, but Escape closes the menu.

If results do not reflect recent edits, Excel may need to reapply the filter. On Windows, Ctrl+Alt+L reapplies the current AutoFilter. This is different from Ctrl+Shift+L: the latter toggles filter controls, while the former refreshes the filtering based on current cell values. If you are unsure which action is needed, check whether the arrows are present and whether the displayed records match the criteria.

Frequently Asked Questions

What is the keyboard shortcut for filters in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off. Click a cell in the data first, or select the complete range if Excel may not detect it correctly.

What is the filter shortcut on a Mac?
In current Excel for Mac, Command+Shift+F is the usual shortcut for applying or removing filters. If it does not work with your setup, use Data > Filter on the ribbon.

How do I clear a filter without removing the arrows?
Open the menu on the filtered column and clear its filter criterion. This shows the excluded records again while keeping the filter controls available. Clearing one column does not necessarily clear filters in other columns.

Does Ctrl+Shift+L delete rows in Excel?
No. Filtering hides records that do not match the selected criteria; it does not delete their worksheet data. Turning filters off or clearing criteria makes hidden records visible again.

Why does Ctrl+Shift+L not work?
Make sure Excel has focus, select a cell in the data, and check that the sheet is not protected in a way that prevents filtering. If the shortcut is unavailable or intercepted, use Data > Filter instead.

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.