In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter off or on; this removes the filter arrows and stops filtering. To clear a filter criterion while keeping the arrows, use Alt+A, C on the Data tab, or open the filtered column’s menu and choose Clear Filter From that column.
The quickest shortcut and what it does
Ctrl+Shift+L is Excel’s shortcut for applying or removing AutoFilter. If a filtered range or table is selected, pressing it turns the filter controls off; pressing it again turns them back on. It is handy when you want to remove the filtering interface quickly, but it is not the same operation as clearing one column’s criterion while leaving the other filter arrows available.
For a practical distinction, imagine a list with filters on the Department and Status columns. If Status is set to show only Open items, Ctrl+Shift+L turns AutoFilter off for the range or table. If you want to keep the arrows and restore every department and status, use the Clear command instead. If you want to show all statuses but keep a Department filter, clear only the Status filter from its dropdown.
On many Windows keyboards the shortcut works directly. If it does not, check whether your laptop uses the function row for hardware controls, whether another program has captured the shortcut, or whether the active cell is inside the filtered range. You can always use the ribbon command Data > Filter to toggle the filter controls.
Clear a filter without removing the arrows
When you clear a filter, Excel shows the rows that the criterion had hidden but leaves AutoFilter in place. That is usually what people mean when they ask how to remove a filter: the data becomes visible again, while the dropdown arrows remain ready for another selection.
To clear every active filter on a worksheet’s current filtered list in Excel for Microsoft 365 on Windows:
- Click a cell in the filtered range or Excel table.
- Open the Data tab.
- Choose Clear in the Sort & Filter group. The ribbon access-key sequence is generally Alt, then A, then C.
The key presses are sequential, not a three-key chord: press and release Alt, then press A, then C. In a localized version of Excel or a customized ribbon, access keys can differ; use the on-screen KeyTips after pressing Alt if the letters shown are not the same. The Clear command removes filtering criteria, not the underlying rows or columns.
Clear only one column’s filter
To remove one condition and preserve the others, click the filter arrow in the relevant column header and choose Clear Filter From [column name]. For example, choose Clear Filter From Status to show every status while retaining a filter on Department. This is safer than turning all of AutoFilter off when you want to keep a multi-column view partly narrowed.
There is also a keyboard route if you prefer not to use the mouse: select a cell in the filtered column, press Alt+Down Arrow to open that column’s filter menu, and use the displayed menu access key for the clear-filter command. In many English-language Windows installations, pressing C activates the clear command, but the exact access key can depend on the menu and language. If the letter is not visibly underlined or does not work, use the arrow keys to highlight the command and press Enter.
Clearing a single column does not affect sort order. If the list was also sorted, its rows can remain sorted after the filter is cleared; filtering hides records temporarily, while sorting changes their displayed order.
Filter arrows, criteria, and table behavior
Excel uses AutoFilter controls—small dropdown arrows in header cells—to let you select which records to display. A funnel icon on a header indicates that a filter is active in that column. The rows that do not match are hidden, not deleted. Clearing a filter makes those records visible again, and it does not change the values in the cells.
Excel tables have filter buttons by default. Turning the filter buttons off does not convert a table into an ordinary range: the table remains a table, with its structured formatting and other table features. To hide the arrows while retaining the table, select a cell in the table, open Table Design, and clear Filter Button. To show them again, select that option again. This is a display choice, distinct from clearing filter criteria.
For a normal range, use Data > Filter or Ctrl+Shift+L to toggle AutoFilter. If the range is not recognized, first click inside it and check that it has a single header row. Merged header cells, blank or irregular header rows, and a selection that excludes the data can make filtering behave unexpectedly. Converting a well-formed list to a table with Insert > Table can make its boundaries and headers easier for Excel to manage.
Windows and Mac ways to remove filtering
This article’s main shortcut applies to Excel for Microsoft 365 on Windows. On a Mac, the ribbon is arranged differently and keyboard shortcuts can vary with the keyboard and Excel build. Use Data > Filter to turn filter controls on or off, or open the relevant header dropdown and choose its clear-filter command when you want to keep the controls. On Mac keyboards, the Command key often replaces Ctrl in shortcuts, but do not assume that every Windows sequence has a direct Command-key equivalent.
In Excel for the web, use the Data tab’s filter controls or the dropdown in the column header. Desktop ribbon access-key sequences such as Alt+A, C are not a dependable web shortcut, and browser keyboard commands may take precedence. If a shortcut appears to do nothing, using the visible menu is the clearest way to confirm which operation you are selecting.
Common problems when the shortcut seems not to work
- The filter arrows disappear, but you expected all rows to return. Ctrl+Shift+L toggles AutoFilter. Use Data > Clear or the column dropdown’s clear-filter command to remove criteria while keeping the arrows.
- Some rows are still missing. Check every column for an active funnel icon. A different column may still be filtered, or rows may be hidden manually. Clearing filters does not unhide rows hidden with the row-header context menu or the Format command.
- The command is disabled. Click within the filtered list or table, and check whether the worksheet is protected. Protection settings can restrict filtering; the sheet may need to be unprotected or configured to allow AutoFilter.
- Only part of the list changes. Confirm that the range includes all intended records and that the header row is included. A blank row or separate block of data can cause Excel to treat records as a different region.
- The order is still different. A sort is not a filter. Clearing filter criteria restores hidden rows but does not necessarily return records to their original order. Use the sort controls or restore the original ordering if needed.
Which method should you choose?
Choose based on the result you want, rather than treating every filter command as interchangeable:
- Show all rows but keep the dropdown arrows: use Data > Clear, or clear the active criterion from each relevant column menu.
- Remove the arrows and turn AutoFilter off: press Ctrl+Shift+L on Windows, or choose Data > Filter.
- Show all values in just one column: use that column’s dropdown and choose Clear Filter From [column name].
- Hide table dropdown arrows without changing the table: use Table Design > Filter Button.
A useful habit is to inspect the headers before clearing anything. If several funnel icons appear, one-column clearing will not reveal records excluded by another column’s condition. If the worksheet is shared, remember that clearing a filter changes the visible view for the workbook, which can affect what another person sees when working in the same file.
Frequently Asked Questions
What is the shortcut to clear all filters in Excel?
On Windows, click in the filtered list and use Alt, then A, then C to invoke Data > Clear in many English-language Microsoft 365 installations. Ctrl+Shift+L instead toggles AutoFilter itself, so it is not the best choice when you want to keep the arrows visible.
Does Ctrl+Shift+L delete filtered rows?
No. It turns AutoFilter off or on; it does not delete the records. Filtered-out rows are hidden from view, and clearing the filter or turning filtering off makes them visible again unless they were also hidden separately.
How do I remove a filter from just one column?
Open that column’s header dropdown and choose Clear Filter From followed by the column name. Other column filters remain active, so the list can still show only a subset of the full data.
Why do the filter arrows disappear when I press the shortcut?
Ctrl+Shift+L switches AutoFilter controls off. To keep the arrows while showing all records, use the Clear command on the Data tab instead. For an Excel table, check the Filter Button setting on Table Design if you only want to hide its arrows.
Will clearing a filter restore my original row order?
Not necessarily. Clearing a filter reveals records hidden by the criteria, but it does not undo a separate sort. If you need the original order, use a saved ordering column or another reliable way to restore it; clearing the filter alone cannot infer the prior order.
Related
- Excel Online: Insert an Image Into a Cell
- Excel Online Data Validation: Create a Drop-Down List
- Excel ODS vs CSV: Which Format Should You Use?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula to Add Dates in SequenceTo add dates in sequence in Excel, enter a starting date in A2, then enter =A2+1 in A3…
- VLOOKUP in Excel: Steps, Examples, and Common FixesTo use VLOOKUP in Excel, put the value you want to find in a cell, then enter a…
- Excel Formulas for Difference in Numbers: A Practical GuideTo find the difference between two numbers in Excel, subtract the earlier or starting value from the later…
- Excel Subtotal Filtered Rows: Formula, Steps, and FixesYes. In Excel for Microsoft 365 on Windows, use the SUBTOTAL function to calculate from rows that remain…
- Excel Split Cell After First Space: Formulas and StepsTo split text in Excel after its first space, use =TEXTBEFORE(A2," ") for the text before the space…
- Excel Formula Bar Not Showing? How to Restore ItIf the formula bar is missing in Excel for Microsoft 365 on Windows, open the View tab and,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.