Excel Filter Shortcut: Turn AutoFilter On or Off Fast

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off. To filter the rows, then open a column’s dropdown and choose the values or conditions you want to see; the shortcut adds the filter controls but does not choose a filter for you.

The shortcut and what it does

AutoFilter adds dropdown buttons to the header cells of a data range. Those buttons let you hide rows that do not match a condition, such as a particular region, date period, or product. Pressing Ctrl+Shift+L toggles those buttons for the current data range or selection. It is a quick way to make filtering available without navigating the ribbon.

The distinction matters: pressing the shortcut is not the same as filtering the data. After the buttons appear, you still need to open a dropdown and select criteria. For example, switching AutoFilter on for a sales list does not automatically show only one salesperson’s records; you must choose that person in the Salesperson column’s menu.

When AutoFilter is already on, pressing the shortcut again turns it off. That removes the dropdown controls and generally makes the rows visible again. Do not use the toggle to temporarily hide the controls if you need to preserve a carefully selected filter: turning AutoFilter off can clear the active filter state. Instead, leave it on or clear the specific column’s filter when you want all records back.

Use it on a clean data range

For the most predictable result, organize the data as a simple list: one header row, one record per row, and one type of information per column. Click a cell inside the list, then press Ctrl+Shift+L. Excel usually detects the contiguous data region around the active cell and places dropdowns in its header row. You can also select the whole range, including its headers, before using the shortcut.

Before switching on filters, check that each column has a clear, unique header, such as Date, Region, or Amount. Avoid blank rows or blank columns inside the list because they can make Excel treat part of the data as a separate region. A title or note immediately above the headers can also complicate automatic range detection; select the intended range explicitly if Excel includes the wrong rows.

  1. Click a cell within the data, or select the full range with its header row.
  2. Press Ctrl+Shift+L.
  3. Confirm that dropdown arrows appear in the header cells.
  4. Open the relevant dropdown and select the values or conditions to display.

If there is no header row, Excel may treat the first row of records as headers. That can make the dropdown labels confusing and may effectively exclude that row from the results. Add meaningful headers first, then apply the filter again.

Choose criteria from a column dropdown

Each dropdown offers choices suited to the contents of that column. In a text column, you can check or uncheck particular values, search the list of values, or use text conditions such as “Contains.” In a numeric column, number filters can show values greater than, less than, or between amounts. Date columns offer date-based conditions, including options for periods such as a month or year.

For a simple selection, open the arrow, clear the Select All checkbox, check the items to keep, and confirm. Excel hides the rows that do not meet the selection; it does not delete them. The row numbers may skip as a result, which is a visual clue that some records are hidden by a filter. A filter symbol on a column’s dropdown indicates that a condition is active for that column.

Filters from different columns work together. If you select West in Region and a particular product in Product, Excel displays rows that meet both conditions. This is an AND relationship across the columns, not a choice between either condition. To restore all records, open the relevant dropdown and clear that column’s filter, or use the Clear command on the Data tab to clear filters in the active range.

Filtering a formatted Excel table

An Excel table is often the easiest structure to filter. To make one, select the list and choose Insert > Table, or use Home > Format as Table. Confirm that the selection includes headers. Tables normally display filter arrows in their header row automatically, so you may not need Ctrl+Shift+L to start filtering.

Tables also expand more naturally when you add records below them, and their header controls stay associated with the table. If a table already has filter arrows, use those controls to filter rather than assuming the shortcut must be pressed first. The shortcut can toggle AutoFilter controls, but table behavior can be confusing if you intend to keep the table’s header controls visible. If the arrows disappear, use the table’s ribbon options or press the shortcut again to restore them.

A table is not required. A regular, well-formed range can use AutoFilter too. The choice is practical: use a table when the list will grow or benefits from table features, and use a plain range when you only need basic filtering for a fixed block of cells. In either case, filtering hides nonmatching rows; it does not alter the values stored in the workbook.

Windows, Mac, and Excel for the web

The Windows shortcut for Excel for Microsoft 365 is Ctrl+Shift+L. In Excel for Mac, the commonly used equivalent is Command+Shift+F. If a Mac keyboard, regional layout, or Excel configuration handles that combination differently, use the ribbon command instead: choose Data > Filter.

Excel for the web runs in a browser, where keyboard combinations can vary with the browser and the active shortcut settings. If Ctrl+Shift+L does not toggle the controls, use Data > Filter in the ribbon. On any platform, clicking a cell in the data first helps Excel identify which range you mean. The command’s purpose is the same: show or hide filter dropdowns, then use those dropdowns to set criteria.

How this differs from sorting and Find

Filtering, sorting, and searching answer different questions. Filtering asks, “Which rows should remain visible?” Sorting changes the order of the rows, for example from newest date to oldest or from lowest price to highest. Find searches for text or a value but does not create a continuing view based on multiple column conditions.

These tools can be used together. You might filter a list to show orders from one region and then sort the visible orders by date. The sort changes the order of records, while the filter continues to hide the rows that do not match. If you want to return to the full list, clear the filters rather than assuming that sorting has removed or changed any records.

There is also a difference between filtering a list and hiding rows manually. A filter hides rows according to criteria and can be adjusted from the column dropdown. Manually hidden rows do not necessarily have a filter condition behind them. If some records seem missing, check for active filters before unhiding rows or changing the data.

Common problems and quick fixes

  • No arrows appear: Click inside the list and try the shortcut again, or choose Data > Filter. Check that the range has a header row and that the worksheet is not protected in a way that prevents filtering.
  • Only part of the list gets arrows: Look for a blank row or column splitting the data. Select the intended range, including every header and record, before turning on the filter.
  • The first record looks like a header: Add a proper header row and reapply the filter. Excel may have interpreted the first row of the selected range as headers.
  • Some expected rows are still hidden: A different column may also have an active filter. Check the dropdowns for filter indicators and clear the unwanted conditions.
  • The shortcut does something else or appears ineffective: Confirm that Excel has focus and that the correct sheet is active. On Mac, try Command+Shift+F; in a browser or with a different keyboard layout, use Data > Filter.
  • Turning filters off does not restore a previous view: The toggle is not a reliable way to pause and resume a set of criteria. Reapply the needed selections from the dropdowns, or leave AutoFilter enabled and clear only the conditions you no longer need.

Also check that the data is not split into separate blocks by notes or subtotals. If the range includes merged cells or inconsistent header content, filter controls may be awkward or the detected range may not match what you intended. A clean rectangular list is easier to filter and easier for other spreadsheet tools to interpret.

A quick example with a sales list

Suppose a worksheet has headers in row 1 for Order Date, Region, Product, and Sales, with one order per row. Click a cell within that list and press Ctrl+Shift+L. Open the Region dropdown and select West. Excel hides orders from the other regions. Next, open the Product dropdown and select a product such as Desk. The remaining visible rows are orders that are both in West and for Desk.

If you want to compare all products in West, clear only the Product filter and keep Region set to West. If you want the complete list again, clear Region as well. None of these steps deletes orders. If you copy or summarize the data afterward, remember that filtered rows remain in the worksheet even though they are not currently visible; check the destination or analysis method if you intend to use visible rows only.

Frequently Asked Questions

What is the Excel shortcut to turn filters on?

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L with a cell in the data range selected. Pressing it again toggles AutoFilter off.

Does Ctrl+Shift+L filter the data automatically?

No. It adds or removes the header dropdown controls. Choose criteria from a dropdown to hide rows that do not match.

What is the filter shortcut on a Mac?

The commonly used Mac shortcut is Command+Shift+F. If it does not work in your setup, use Data > Filter in the Excel ribbon.

How do I clear a filter without removing the dropdown arrows?

Open the filtered column’s dropdown and choose its clear-filter option, or use the Clear command on the Data tab. This clears criteria while leaving filtering available.

Can I filter an Excel table with this shortcut?

Yes, but tables usually show filter arrows in their headers automatically. Use the existing dropdowns; if the controls have been toggled off, restore them with the ribbon or shortcut.

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.