In Excel for Microsoft 365 on Windows, press Alt, then A, then C to clear the active filter criteria. The rows reappear while the filter dropdown arrows stay in place, so you can filter the data again without setting up AutoFilter from scratch.
The Windows shortcut, step by step
The sequence Alt+A+C uses Excel’s ribbon Key Tips. Press the keys one after another rather than holding all three down together:
- Click a cell inside the filtered data, or make sure the relevant worksheet is active.
- Press
Alt. Letters and other Key Tips appear on the ribbon. - Press
Ato open the Data tab’s Key Tips. - Press
Cto choose Clear.
Excel removes the current filter selections, making rows hidden by those selections visible again. If the sequence does not work, use the ribbon path Data > Clear in the Sort & Filter group. The shortcut is a quick way to reach that command; it does not require opening each column’s dropdown menu.
Key Tips can depend on the ribbon layout, language, or Excel version. If the letters shown on screen differ, follow the displayed prompts rather than guessing. In the standard English Windows ribbon, Alt+A+C is the usual sequence.
What clearing a filter changes
A filter controls which records Excel displays; it does not delete records that fail the criteria. For example, if a sales table is filtered to show only the West region, rows for the East and Central regions are hidden from view, not removed from the workbook. Clearing the filter restores those rows to view.
Clearing criteria is different from turning filtering off. After using Alt+A+C, the dropdown arrows generally remain in the header row, ready for another selection. The command also does not erase cell contents, remove a table, or change the underlying values. It changes the current view of the data.
This distinction matters when a worksheet seems to be missing information. Before assuming rows have been deleted, check whether a filter is active: a filter button may show a funnel icon, and the row numbers may skip values. Clear the filter, then check whether the records return.
Clear one column or clear the current filters
The keyboard sequence is useful when you want to clear filter criteria quickly. To clear just one column’s criteria while leaving filters on other columns in effect, use that column’s dropdown instead:
- Click the filter arrow in the column header.
- Choose Clear Filter From followed by the column name.
The exact wording can vary slightly with the selected column and Excel interface. For instance, clearing the Region filter while retaining a Year filter will show all regions for the currently selected year, rather than showing every year and region.
Use Data > Clear when you want to remove the applied filter criteria more broadly from the active worksheet’s filtered data. If a sheet contains multiple independently filtered Excel tables, check each table afterward; clearing one table’s criteria does not mean every other table has the view you want. This is especially useful on dashboards or sheets that contain several separate lists.
Clearing a filter is not the same as removing AutoFilter
A common source of confusion is the shortcut Ctrl+Shift+L. In Excel for Windows, it toggles filter buttons on or off for a selected data range. It is not the shortcut for clearing filter criteria. If you press it to make filtered rows reappear, you may turn the arrows off instead of simply resetting the current selections.
To remove the dropdown arrows, select a cell in the filtered range and use Data > Filter, or use Ctrl+Shift+L to toggle filtering off. To keep the arrows and show all records again, use Alt+A+C. If you turn filtering off and later turn it back on, Excel may retain or restore the previous criteria depending on the range and current state, so clearing first is the clearer choice when you want a visibly unfiltered list.
How filters behave in tables and ordinary ranges
Excel applies filters to a data list or table, usually using the header row to identify each field. In an Excel table, filter arrows are normally part of the table’s header. In an ordinary range, you can add them with Data > Filter. The clear command changes which rows are displayed; it does not convert a range into a table or alter the table’s structure.
Imagine a table with columns for Date, Region, and Product. If Region is set to West and Product is set to Chairs, the visible records must meet both conditions. Clearing the criteria restores records excluded by either selection. By contrast, clearing only the Region filter leaves the Chairs condition active. That difference can explain why some rows remain hidden after you clear just one dropdown.
When working with several tables on one worksheet, click inside the specific table before using a table-level command, and then verify the other lists separately. Filters can be independent between tables, so do not assume one visible set of arrows represents every list on the sheet.
When the shortcut does not seem to work
If Alt+A+C has no effect, first confirm that Excel has focus and that the filtered worksheet is active. If a cell is being edited, press Enter or Esc to finish editing before trying the sequence. Then check that the data actually has a filter applied; if there are no active criteria, clearing them may produce no obvious change.
- Nothing changes: Use Data > Clear and look for rows that were hidden by the filter.
- The arrows disappear: You probably toggled Filter off. Re-enable it with Data > Filter, then clear the criteria.
- Some rows are still hidden: Another column or another table may still have a filter. Inspect the relevant dropdowns and table headers.
- Rows remain hidden after clearing: Check for manually hidden rows, grouped or collapsed rows, or a different view issue. A filter is not the only reason rows can be out of sight.
Also make sure you are looking at the intended worksheet. The command changes a filter view, not the workbook’s stored records, and it cannot restore data that was actually deleted. If a filter arrow shows a funnel, opening that dropdown can reveal which selections are active.
Excel for Mac and Excel for the web
The Alt+A+C sequence is for the standard Windows ribbon and should not be assumed to work on a Mac. In Excel for Mac, use the Data tab and choose Clear in the filtering or sorting controls when available. To clear only one field, open its header dropdown and choose the option to clear that field’s filter. Ribbon labels and keyboard navigation can vary by Mac release, so the visible command is the dependable guide.
In Excel for the web, use the Data tab’s clear-filter command when it is available in the ribbon, or clear the criteria from the relevant column dropdown. Browser and web-app keyboard handling can differ from desktop Excel, so the Windows Key Tip sequence may not behave the same way. The underlying idea is unchanged: clear the criteria to show the rows again; do not toggle filtering off unless you want to remove the dropdown controls.
Frequently Asked Questions
What is the shortcut to clear a filter in Excel?
In Excel for Microsoft 365 on Windows, press Alt, A, then C. It clears active filter criteria while leaving filter controls available.
Does Alt+A+C delete filtered rows?
No. It clears the criteria that hide rows. Records excluded by the filter become visible again; the shortcut does not delete their contents.
How do I clear a filter from just one column?
Open that column’s filter dropdown and choose Clear Filter From followed by the column name. Filters in other columns can remain active.
Does Ctrl+Shift+L clear a filter?
No. In Excel for Windows, it toggles filter buttons on or off. Use Alt+A+C to clear criteria while keeping the dropdown arrows.
Why are rows still missing after I clear the filter?
Another column or table may still be filtered, or rows may be manually hidden or collapsed. Check the other filter dropdowns and the row headings to find the cause.
A quick way to remember the difference
Think of the commands as doing two separate jobs: Alt+A+C clears the current filter selections, while Ctrl+Shift+L toggles the filter controls. If your goal is to see all records and keep the arrows ready for later, use the first sequence. If your goal is to remove or restore the arrows, use the second command or the Data tab. This small distinction prevents a common mistake and makes it easier to tell whether Excel has changed the view or the filtering setup.
Related
- Excel Print Top Row on Every Page
- Excel Power Query Takes Too Long to Refresh? Fixes
- Excel Power Query vs Access: Which Tool Fits Your Data?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- COUNTIF Excel: How to Reference Cells in CriteriaTo make COUNTIF use a cell as its criterion, put the cell reference in the second argument: with…
- How to Multiply Different Cells in Excel With a FormulaTo multiply different cells in Excel, select an empty cell, type a formula that starts with an equals…
- Excel COUNTIF for Red Text: Methods That Actually WorkCOUNTIF cannot directly count cells by red font color: it evaluates cell values, not formatting. To count red…
- Excel Table Header Formula: What Works and What Doesn’tExcel table headers are column labels, not the place to put a formula you expect to calculate or…
- Excel MID Function: Extract Text from the Middle of a CellExcel’s MID function extracts a chosen number of characters from the middle of a text string. Its syntax…
- Can You Sort Excel by Color? Steps and TipsYes. In Excel for Microsoft 365 on Windows, select your data and choose Data > Sort, then set…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.