Excel Filter Shortcut: How to Add or Remove Filters

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to add filter drop-downs to the current data range; press it again to remove them. In Excel for Mac, the shortcut is usually Command+Shift+F; you can also use Data > Filter if a shortcut is unavailable or behaves differently on your setup.

What the Excel filter shortcut does

Ctrl+Shift+L turns Excel’s AutoFilter on or off for the current list or table. When you turn it on, Excel adds a small drop-down arrow to each column heading in the detected data area. Those arrows let you show only rows that match selected values or conditions, such as one region, a date range, or text that contains a word.

The shortcut does not insert a new worksheet, rearrange the underlying records, or delete rows that do not match. Filtering temporarily hides nonmatching rows from view. The data remains in the workbook, and clearing a filter makes the hidden rows visible again. This distinction matters when reviewing totals or copying data: a filtered view is not the same as a separate, permanent extract.

The shortcut is a toggle. If arrows are already visible, pressing it again removes the filter controls for the active list or table. It is not a command to clear the chosen criteria while keeping the arrows. To show all rows but leave the controls in place, use the relevant column menu and choose the option to clear that column’s filter.

Prepare the data before turning on filters

Excel needs a recognizable header row and a continuous block of records to filter reliably. Before using the shortcut, check that each column has a meaningful heading and that the records beneath it follow the same layout. A heading such as Order Date or Status is more useful than an empty cell or a repeated generic label.

For a straightforward list, click any cell inside the data before pressing Ctrl+Shift+L. Excel generally detects the surrounding contiguous region and adds arrows to its headings. Selecting a cell outside the list, or placing a blank row or column inside the records, can cause Excel to detect the wrong area or split the data into separate regions.

  • Use one header row, with a different heading for each field.
  • Avoid completely blank rows or columns inside the records.
  • Keep one kind of information in each column, such as dates in a date column and prices in a price column.
  • Remove merged cells from the data area when possible; merged layouts are awkward to sort and filter as a list.

If your data has a title or notes above the header row, click within the actual records rather than the title area. For uncertain or irregular layouts, select the exact range first, then use Data > Filter. Review the arrows to confirm they appear on the intended header row.

Turn filters on step by step

  1. Click a cell within the list you want to filter. If you want to control the precise area, select the header row and all of its data cells.
  2. Press Ctrl+Shift+L on a Windows keyboard. On Mac, try Command+Shift+F.
  3. Check that a drop-down arrow appears beside each column heading.
  4. Open the arrow for the field you want to inspect, select the values or condition, and apply the filter.

For example, a sales list might have headings for Date, Region, Product, and Revenue. To see only West-region transactions, open the Region arrow, clear the selection for all values if necessary, select West, and apply the selection. Other columns keep their own menus, so you can add another condition—for example, a particular product—without replacing the region filter.

The ribbon alternative in Excel for Microsoft 365 on Windows is Data > Filter. You can also use Home > Sort & Filter > Filter. These commands perform the same basic on/off action as the keyboard shortcut and are useful if you forget the keys or use a keyboard without a dedicated Ctrl key.

How Excel’s filter menus work

Each column’s menu is based on the values and data type Excel finds in that column. For a column of categories, the menu lists distinct values with checkboxes. Choosing one or more values limits the visible rows to records containing those values. In a date or number column, Excel can also offer condition-based options, such as comparisons or ranges; text columns offer text conditions such as begins with or contains.

Many filter menus include a search box, which helps when a column has a long list of distinct entries. Searching narrows the values displayed in the menu; it does not change the cell contents. You can then select the matching item or items and apply them. If the intended value does not appear, check whether another filter is already hiding the rows that contain it, or whether the data has extra spaces or inconsistent spellings.

Filters on separate columns combine to narrow the visible results. If you select West in Region and a specific item in Product, Excel displays rows satisfying both choices. This is useful for exploratory analysis, but it can also make a list appear empty if the combination does not occur. Clear one condition at a time to find which selection is excluding the records you expected to see.

Filtering a range versus an Excel table

AutoFilter can be applied to an ordinary range, but converting a well-structured list to an Excel table is often convenient. Select a cell in the data and use Insert > Table, or press Ctrl+T on Windows. Confirm that the range is correct and that the table has headers. Tables include filter buttons in their header row by default, and they generally expand when you add records directly below or beside them.

Tables also provide features beyond filtering, such as structured references in formulas and consistent formatting. They are not required to use Ctrl+Shift+L, however. A normal rectangular data range can be filtered without being converted to a table. Choose a table when the data is an ongoing list that will grow; a simple range may be sufficient for a one-time review or a layout that cannot be made into a clean table.

When working with an existing table, its header drop-downs are part of the table interface. Avoid assuming that a visible arrow means a filter is actively limiting the records: a table can show its controls while no criteria are applied. Look for filter indicators in the menus or check whether expected rows are missing before concluding that the data has been changed.

Useful examples and related controls

Filtering is useful whenever you need to focus on a subset without changing the source list. A project tracker could show only items marked In Progress. An inventory sheet could show products below a chosen stock level. A contact list could display one city, while a transaction log could isolate dates in a particular period. In each case, choosing a filter changes which records are visible, not the values stored in the cells.

Sorting and filtering are related but different. Sorting changes the order of records—for example, arranging revenue from largest to smallest—whereas filtering hides records that do not match a condition. Both controls appear in the column menus, and you can sort a filtered result. If you need the original order back later, consider adding an ID or sequence column before sorting so the starting order can be restored.

When a filtered list is used for calculations, be aware that some ordinary totals include values in hidden rows. Excel’s SUBTOTAL function is designed for lists and can calculate over visible filtered records. For example, with revenue values in D2:D100, =SUBTOTAL(9,D2:D100) returns a sum that excludes rows hidden by a filter. The function number 9 specifies SUM. This formula assumes the revenue values occupy D2:D100; it returns the sum of the currently visible values in that range, not a fixed result independent of the filter.

Turn filters off, clear criteria, or show all rows

There are three actions that are easy to confuse. First, pressing Ctrl+Shift+L again turns the filter controls off for the current data area. Second, clearing a filter removes the criteria but leaves the arrows available. Third, showing all records may be done from the Data tab’s clear-filter command or from an individual column menu, depending on whether you want to clear one field or all active criteria.

If you only want to undo a recent selection, open the filtered column’s menu and choose its clear-filter option. To clear active filters across the list, use Data > Clear in Excel for Microsoft 365 on Windows. The arrows remain, so you can apply a different filter without setting AutoFilter up again. If you turn the filter off with the shortcut, existing rows become visible, but you also remove the drop-down controls.

When the purpose is to extract a subset for a separate report, filtering alone does not create a new dataset. You can select and copy the visible results, but take care to copy the intended visible cells and headings. Keep the original data intact if you may need to audit or revise the criteria later.

Windows, Mac, and Excel for the web

This page focuses on Excel for Microsoft 365 on Windows, where Ctrl+Shift+L is the standard shortcut for turning filters on or off. On Mac, Command+Shift+F is the commonly used equivalent. Keyboard behavior can depend on the Excel release, keyboard layout, and system-level shortcuts, so the ribbon command is a dependable alternative: choose Data > Filter in the desktop app.

Excel for the web also offers filtering from the Data tab, but browser shortcuts and keyboard focus can affect whether a key combination reaches Excel. If the shortcut does not work in a browser, click a cell in the data and use the ribbon command instead. The command path and available options can vary slightly as Microsoft updates the web interface, while the underlying idea—apply or remove filter controls for a list—remains the same.

Common problems and how to fix them

  • No arrows appear: Click inside the intended list and press the shortcut again, or use Data > Filter. Check that the selection is in the data and that the worksheet is not protected in a way that prevents filtering.
  • Arrows appear on the wrong row: Excel may have detected a title row or a separated block as the list. Select the precise header-and-data range before choosing Data > Filter.
  • Some records are missing: Look for active criteria in other column menus, hidden rows, or inconsistent values such as North and north. Clear filters to verify the full list.
  • The shortcut types or triggers something else: Make sure Excel has focus and the active cell is in the list. On Mac or in a browser, try the platform-specific shortcut or use the ribbon command.
  • New rows are not included: A filtered ordinary range may not expand as expected when data is added elsewhere. Add rows directly adjacent to the range, reapply the filter to the full area, or consider using an Excel table for a growing list.

Also check for blank cells in the header row and inconsistent data types. A column containing a mixture of real dates and text that merely looks like dates may not offer the expected date-filter choices. Standardizing the column’s contents can make the menu easier to use and reduce confusing results.

Frequently Asked Questions

What is the shortcut to add a filter in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L while a cell in the data is selected. It adds filter arrows to the detected list or table; pressing it again turns the controls off.

Does Ctrl+Shift+L delete rows that do not match?
No. A filter 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 but keep the drop-down arrows?
Open the relevant column’s filter menu and choose its clear-filter option. To clear criteria for the whole list, use Data > Clear. The filter controls stay available.

Why does Ctrl+Shift+L not work in Excel?
First click a cell in the data and make sure Excel has focus. If the shortcut is intercepted or your platform uses different keys, use Data > Filter. Also check whether worksheet protection limits filtering.

What is the filter shortcut on a Mac?
In Excel for Mac, Command+Shift+F is commonly used to turn filters on or off. If it does not work in your version or setup, use Data > Filter from the ribbon.

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.