Excel Filter Remove Shortcut Keys: Clear or Toggle?

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter arrows on or off; to clear filter criteria but keep the arrows, choose Data > Clear. These actions are different: toggling the filter removes the controls, while clearing filters shows the hidden rows and leaves the controls available.

Excel filter shortcuts at a glance

The word “remove” can mean either removing the filter buttons from the column headings or removing the conditions that are hiding rows. Choose the action that matches what you want to see afterward.

Turn AutoFilter on or off: Select a cell in the filtered list and press Ctrl+Shift+L on Windows.
Clear all active filter criteria: Use Data > Clear. The filter arrows remain, and rows hidden by filters appear again.
Clear one column’s criteria: Open that column’s dropdown and choose Clear Filter From followed by the column name.
Open a column’s filter menu: Select a cell in its header and press Alt+Down Arrow on Windows.

There is no single standard Windows shortcut that clears every filter criterion while preserving the arrows in all Excel workbooks. The Data tab command is the dependable way to clear them all.

What toggling a filter actually does

AutoFilter adds dropdown buttons to the headers of a data range. Those buttons let you display selected values, apply conditions such as “greater than,” and sort the rows. When a filter is active, Excel hides rows that do not match the chosen criteria; it does not delete those records.

Pressing Ctrl+Shift+L toggles the filter controls for a selected range. If the controls are already on, toggling them off removes the dropdown buttons and returns the data to an unfiltered display. It is therefore a quick way to make the arrows disappear, but it is not the best choice if your goal is simply to show all records and keep filtering ready for later.

To restore the controls, select a cell in the list and press Ctrl+Shift+L again. Excel generally identifies the contiguous data region around the selection. Check the header row and the range before using the shortcut if the worksheet has blank rows or columns that divide the data into separate blocks.

Clear criteria and keep the dropdown arrows

If you want every row visible but want to keep the filter buttons, use Data > Clear on the ribbon. In the standard Microsoft 365 Windows ribbon, this command is in the Sort & Filter group on the Data tab. It removes the applied filter conditions from the current filtered list; it does not erase cell contents or remove the header dropdowns.

For example, imagine a sales table filtered to show only the West region and orders above $500. Choosing Data > Clear removes those criteria, so records from every region and at every order amount are displayed again. The filter arrows remain, ready for another selection. This is different from deleting visible rows: clearing a filter restores the hidden records rather than removing them from the workbook.

If you only need to clear one condition, use that field’s menu. Click the dropdown in the Region heading and select Clear Filter From “Region” (the wording names the column). The other column’s order-amount filter remains active. This is useful when you have several filters and want to relax just one of them without rebuilding the others.

Remove filter arrows from a worksheet range

For an ordinary range with AutoFilter enabled, select a cell in the list and press Ctrl+Shift+L. The arrows disappear. You can also use the ribbon command Data > Filter to toggle the filter controls. If you are unsure whether the selection belongs to the intended range, click inside the list first rather than selecting an unrelated cell elsewhere on the sheet.

Before turning filtering off, consider whether you need to preserve the current criteria. If the filtered rows are hidden, toggling AutoFilter off makes the data display unfiltered, but it also removes the filter interface. If you need the criteria cleared while leaving the interface in place, use Data > Clear instead.

Excel tables have a related but distinct control. A formatted table normally includes filter buttons in its header. Select a cell in the table to show the contextual Table Design tab, then clear the Filter Button option in the Table Style Options group to hide the buttons while retaining the table. To show them again, select Filter Button once more. This is the more targeted method when you want the table structure and formatting to stay intact.

Use the column dropdown for a precise change

When you want to inspect or adjust one field, the dropdown menu offers the most context. On Windows, select a cell in the relevant header and press Alt+Down Arrow to open its filter menu. You can then review checked values or choose a clear-filter command. The exact choices depend on the column’s contents and the kind of filter applied.

For example, a date column may offer date-specific filtering options, while a column of text values may list distinct names or categories. A checked list can make it easy to see which values are currently included, but a condition-based filter may be less obvious from the list alone. Use the menu’s clear-filter command for that column when you want to remove its condition without affecting filters elsewhere.

Keyboard navigation within the menu can vary with the menu contents and Excel build, so do not rely on one letter key as a universal clear command. Alt+Down Arrow is the useful shortcut for opening the menu; choosing the clearly labeled command is the reliable next step.

Windows, Mac, and Excel for the web

The Windows shortcut most people mean by “Excel filter shortcut” is Ctrl+Shift+L. On Mac, the AutoFilter toggle is commonly Command+Shift+F; shortcut behavior can depend on the Excel version and keyboard settings. If the Mac shortcut does not work, use the ribbon’s Data > Filter command instead. Mac keyboards may also label the Option key differently, but it is not needed for these filter actions.

In Excel for the web, use the Data tab’s Filter command and the dropdown in the relevant column. Browser and operating-system shortcuts can be intercepted by the browser, so the ribbon is a practical alternative when a keyboard combination does not respond. The exact ribbon layout can vary slightly by platform, but the distinction remains the same: clear criteria to show rows while retaining filter controls; turn filtering off to remove controls.

For a workbook shared across Windows, Mac, and web users, menu commands are often easier to communicate than a shortcut alone. A note such as “Data > Clear to show all rows” avoids confusion over platform-specific keys and makes clear that the filter arrows will remain.

Common problems and misconceptions

Rows are still missing after you clear a filter: Check each column dropdown. Another field may still have an active condition, or rows may be hidden manually. Use Data > Clear for filter conditions, then inspect row headings for manually hidden rows.
The arrows did not disappear: Confirm that your active cell is inside the filtered range, or check whether the data is an Excel table. For a table, use Table Design > Filter Button.
Ctrl+Shift+L applies a filter instead of removing one: The shortcut toggles the feature. If the selected range did not already have AutoFilter, it may turn filtering on. Press it again to toggle it off, or use Data > Clear if you only wanted to show every row.
Some records seem deleted: A filter hides nonmatching rows; it does not delete them. Clear the criteria or turn off the filter to display the full list.
The command affects the wrong data: Verify the selected cell and the boundaries of the data range. Blank separator rows or columns can cause Excel to treat nearby blocks as separate lists.

Also distinguish filter-hidden rows from manually hidden rows. Data > Clear removes filter criteria, but it does not necessarily unhide rows that someone hid with a row command. If the filter is cleared and a gap remains in the row numbers, select the affected row headings, right-click, and choose Unhide.

Which method should you choose?

Use the result you want as your guide. For a quick temporary view with all records visible and the dropdowns still available, choose Data > Clear. To remove a single field’s condition, clear that column’s filter from its dropdown. To make the arrows disappear from an ordinary range, toggle AutoFilter off with Ctrl+Shift+L. For a table whose buttons should be hidden while the table remains a table, use Table Design > Filter Button.

Sorting is separate from filtering. Turning filtering off does not necessarily restore the original row order after a sort. If order matters, sort by a stable ID or by a saved sequence column before filtering, or keep an original copy of the data. Likewise, copying only visible cells is a separate operation: clearing filters first can change which records appear in a later copy, so check the visible rows before copying.

Frequently Asked Questions

What is the shortcut to remove filters in Excel?
On Windows, Ctrl+Shift+L toggles AutoFilter arrows on or off for a selected range. To clear filter conditions while keeping the arrows, use Data > Clear instead.

How do I clear all filters but keep the arrows?
Choose Data > Clear on the Data tab. Excel removes the active filter criteria and displays the rows again, while leaving the dropdown controls in place.

How do I remove a filter from just one column?
Open that column’s dropdown and choose Clear Filter From followed by its name. Filters on other columns remain in effect.

Does Ctrl+Shift+L delete filtered rows?
No. Filters hide rows that do not match; they do not delete them. Toggling filtering off displays the data without the filter controls.

What is the filter shortcut on Mac?
Command+Shift+F is commonly used to toggle AutoFilter in Excel for Mac. If it is unavailable in your version or keyboard setup, use Data > Filter.

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.