Excel Shortcut to Remove Filters: Clear vs Turn Off

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter off and remove the filter arrows. To clear the current filter results but keep the arrows available, use Alt+A, C or choose Data > Clear—the right shortcut depends on what you mean by “remove filters.”

Two different ways to remove a filter

Excel uses filters to hide rows that do not match selected criteria. A filtered list might show only orders from one region, for example, while leaving the other rows in the worksheet rather than deleting them. Because “remove filters” can refer to two different actions, it helps to decide whether you want to show every row or remove the filter controls as well.

Clear a filter: Show all rows again while keeping the drop-down arrows and AutoFilter feature in place. On Windows, press Alt+A, C, or use Data > Clear.
Turn filtering off: Remove the filter arrows from the filtered range or table. Press Ctrl+Shift+L on Windows.

In the first shortcut, press and release the keys in sequence: hold Alt, press A, then press C. It is not a three-key combination. The commands apply to the AutoFilter range or table containing the active cell, so click inside the relevant data before using them.

How to clear filters and show all rows

Clearing is usually the better choice when you expect to filter the same data again. It restores rows hidden by the current filter, but leaves the filter controls in place. On Windows, follow these steps:

Click a cell inside the filtered range or Excel table.
Press Alt+A, C. Alternatively, open the Data tab and select Clear in the Sort & Filter group.
Check that the rows you expected to see have returned. The filter arrows should still appear in the column headings.

The Clear command removes active filter criteria from the current filtered data; it does not delete the underlying records. For example, if a sales table is filtered to show only the West region, clearing the filter brings back the East, Central, and other regions too. The table and its headings remain intact, ready for another selection.

If the Clear command appears unavailable, first click within the filtered list or table. Also check whether the rows are hidden for another reason: manually hidden rows, grouped or collapsed outline levels, and worksheet filters are not necessarily undone by clearing an AutoFilter. The filter arrows themselves are a useful clue that a range or table has filtering enabled.

How to turn filter arrows off

Use Ctrl+Shift+L when you want to remove the drop-down arrows and stop using AutoFilter on the current data. Click inside the filtered range or table, then press the shortcut. You can also use the ribbon: select Data > Filter. The Filter button toggles filtering on or off.

When you turn AutoFilter off, Excel displays the rows again and removes the filter controls from the range. This differs from clearing a filter: clearing keeps the controls, while turning filtering off removes them. If your goal is only to restore the full list temporarily, Clear is generally more convenient because you can immediately filter again from the same headings.

In a formatted Excel table, the heading drop-downs are part of the table’s filter controls. Turning off filtering for a table removes those controls; it does not convert the table into an ordinary range or delete its data. Table design and table features remain, and you can enable the controls again through the Filter command or the table options available in your version of Excel.

What happens to sort order and data

Filtering and sorting are related tools, but they do different things. A filter hides rows that do not match a condition; a sort changes the order of rows. Clearing a filter reveals the hidden rows, but it does not necessarily restore the original order the list had before someone sorted it. If the visible records are still arranged by date or name, that is likely a sort order rather than a filter.

Neither Clear nor the Filter toggle is intended to delete records. If rows appear to be missing after a filter is cleared, check for other causes before assuming the data was removed. Look for manually hidden rows, collapsed groups, an active filter on another table or range, or a worksheet view that differs from the one you expect. You can also inspect the row numbers: gaps can indicate hidden rows, though they do not by themselves identify why the rows are hidden.

Before changing a complex workbook, consider saving it if the current view or sort order matters. A clear action is reversible in the practical sense that you can apply a filter again, but Excel does not keep a separate history of every filter selection once it has been cleared. Undo may reverse a recent action, but relying on it is less dependable than knowing which command you used.

Using the shortcut with tables and ranges

Excel can filter a normal data range when AutoFilter is enabled, and it can filter a formatted table using the table’s heading controls. The shortcuts are useful in either case, but the active cell matters: Excel needs to determine which filtered data set you mean. If a worksheet contains several separate lists, click inside the specific one before pressing a shortcut or choosing a ribbon command.

For a clean result, each data column should have a clear heading, and the list should not have blank rows or blank columns breaking it into separate blocks. Excel uses the surrounding data structure to identify the range. If the wrong range is selected or the command does not affect the list you intended, click directly in the list and try again. For a table, selecting any cell inside the table is normally sufficient.

Here is a practical example: a table has columns for Date, Region, and Sales, and a filter currently shows only West-region orders. Pressing Alt+A, C restores all regions while preserving the heading arrows. Pressing Ctrl+Shift+L instead turns filtering off and removes those arrows. Neither action changes the Sales values or deletes the orders.

Windows, Mac, and Excel for the web

The main shortcut in this answer is for Excel for Microsoft 365 on Windows. Keyboard shortcuts can differ on Mac, and they may also depend on keyboard settings or the version of Excel. On Excel for Mac, Command+Shift+F is commonly used to toggle filtering; Control+Shift+L may also work in supported configurations. If a shortcut is intercepted or does not work, use the ribbon command instead.

On Mac, use the Data tab and its filter controls to clear or toggle filters. On Excel for the web, use the Data tab and the available Filter or Clear commands; browser and keyboard settings can affect shortcut behavior. The ribbon is the most dependable way to identify the action in a different platform: choose Clear to remove criteria while retaining filtering, or switch Filter off to remove the controls.

Shortcuts can also vary when a laptop keyboard requires an Fn key, when Excel is running in a remote desktop session, or when another application reserves the same key combination. If Ctrl+Shift+L does not appear to do anything, click in the data and use Data > Filter to check whether AutoFilter is on. If Alt-based key tips differ in your installation, follow the access-key letters shown on the ribbon rather than assuming a sequence.

Common problems and quick checks

The rows remain hidden after using the shortcut. You may have toggled filtering off in a different range, or the rows may be hidden manually or grouped. Click inside the intended list and use Data > Clear, then check row visibility and outline controls.
The arrows disappeared, but you wanted to keep them. You turned filtering off. Re-enable it with Ctrl+Shift+L or Data > Filter, then clear the criteria with Alt+A, C.
Some rows return, but the list still looks incomplete. Check every filtered column. A filter on one column can be combined with criteria in another, so clearing the relevant range’s filters is safer than changing only one heading’s selection.
The list is still in an unexpected order. Clearing filters does not undo sorting. Use the relevant sort command or sort the data by a column that reflects the order you need.
The command seems to affect the wrong data. Click a cell inside the intended table or range first. If separate data blocks are close together, confirm that Excel has identified the correct block.

Frequently Asked Questions

What is the Excel shortcut to clear filters but keep the arrows?
On Windows, click inside the filtered data and press Alt+A, C. You can also choose Data > Clear. This clears filter criteria while leaving the AutoFilter controls available.

Does Ctrl+Shift+L clear a filter in Excel?
Ctrl+Shift+L toggles AutoFilter on or off; it is not the best choice when you only want to clear filter criteria and keep the arrows. Use Alt+A, C or Data > Clear for that task.

How do I remove filter arrows without deleting a table?
Click in the table and press Ctrl+Shift+L, or select Data > Filter to turn filtering off. This removes the filter controls; it does not delete the table or its records.

Will clearing a filter delete hidden rows?
No. Clearing a filter shows rows that were excluded by the filter; it does not delete them. If rows are still missing, check whether they were manually hidden, grouped, or affected by another filter.

Why does clearing filters not restore my original row order?
A filter controls which rows are visible, while a sort controls their order. Clearing the filter reveals the matching rows again but does not necessarily undo a previous sort. Sort the data separately if you need a particular order.

What is the Mac shortcut for turning filters off?
In Excel for Mac, Command+Shift+F is commonly used to toggle filtering, and Control+Shift+L may work in supported configurations. If neither works, use the Data tab’s Filter control; menu commands are more consistent across keyboard setups.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.