Clear Filters in Excel: Reset and Reapply the Right Way

A filtered sheet with no error message is the most disorienting thing Excel can do to you. If your row count looks wrong and you can't figure out why, there's a good chance a filter is still active somewhere, and the dataset is silently hiding data you think should be there. I've watched this confuse experienced analysts. I've done it myself.

This guide covers the full roundtrip: clearing filter criteria, reapplying them after data changes, and automating the reset with a short VBA snippet. If you're new to filtering altogether, the introduction to sorting and filtering in Excel is a good place to start first.

What You Can Reset — and the Key Difference Between Clearing and Removing a Filter in Excel

Before touching any button, the distinction matters. Clearing a filter removes the active criteria but leaves the AutoFilter dropdowns in place. Your column headers still have those little arrows. Removing a filter (by clicking the Filter button on the Data tab) toggles AutoFilter off entirely and takes the dropdowns with it.

Most guides treat these as interchangeable. They're not. If you click the wrong one, you'll lose your dropdowns and have to rebuild them.

One important boundary to understand: clearing filters only resets what AutoFilter is hiding. Any rows that were manually hidden using Format > Hide Rows won't reappear when you clear filter criteria. They're hidden by a completely separate mechanism, and this trips people up constantly.

The tell for an active filter is blue row numbers in the row header column. If you see row numbers in blue and gaps in the sequence, AutoFilter is hiding data.

Clear removes filter criteria; Reapply refreshes them against current data. Different buttons, different jobs.

Step 1: Clear All Filters in Excel at Once (or Remove a Filter from One Column)

Now that you know what you're actually resetting, here's how to do it.

Clear all filters at once using the Ribbon

In Microsoft 365 on Windows, go to the Data tab and click the Clear button in the Sort & Filter group. That clears all active filter criteria across every column simultaneously. The AutoFilter dropdowns stay. Your data comes back.

The keyboard shortcut is Alt → A → C (press in sequence, not simultaneously). Once you have it in muscle memory, it's faster than reaching for the mouse.

On Excel for Mac, the Clear button is in the same Data tab location, but the Alt-key shortcut pattern doesn't apply. Use the ribbon on Mac. Excel Online also has the Clear button under the Data tab, though the layout is more compressed.

Remove a filter from a single column using the dropdown

1. Click the filter dropdown arrow on the column you want to reset.
2. Select Clear Filter From [Column Name] near the top of the dropdown menu.
3. Click OK or press Enter.

This leaves every other column's filter criteria untouched. If you're working with a report that has four or five active filters and you only need to reset one, this is the right move. Clearing all filters when you only need one reset is an easy way to lose work.

Step 2: Reapply a Filter in Excel After New Data Is Added

Once you've cleared what you needed to clear, here's a scenario that bites people regularly: you add new rows to a filtered dataset, and those rows don't show up, even though they should match the filter criteria.

The filter doesn't update automatically. It evaluated your data when you set the criteria, and it's still showing results based on that snapshot. The fix is the Reapply button, right next to Clear on the Data tab. It forces AutoFilter to re-evaluate all existing filter criteria against the current state of the data. The keyboard shortcut is Alt → A → Q.

Reapply is not a reset. It keeps your criteria intact and re-evaluates them against your current data. Clear is the reset; Reapply is the refresh.

If your Excel basics are still getting settled, the distinction between resetting and refreshing a filter is one of those things worth locking in early. It'll save you a lot of confused staring at your screen.

For Excel Tables (formatted with Ctrl+T), filter criteria are saved with the workbook. For a plain cell range with AutoFilter applied, only filter criteria are saved — sort criteria are not. Reapply handles the filter side; sorts need to be re-run manually.

Step 3: Clear Filters in Excel Using VBA to Automate the Reset

If you're running the same report repeatedly, or managing a shared workbook where others apply filters and forget to clear them, doing this manually gets old. A short macro handles it cleanly.

Open the VBA editor with Alt + F11, insert a new module, and paste this:

Sub ClearAllFilters()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Worksheets
        If ws.AutoFilterMode Then
            ws.AutoFilter.ShowAllData
        End If
    Next ws
End Sub

ShowAllData clears all filter criteria on every sheet without turning off AutoFilter. The dropdowns stay. This is the key detail: ws.AutoFilterMode = False would remove the dropdowns entirely, which is usually not what you want in a shared or repeating report context.

No deep VBA knowledge required here. Copy, paste, and run.

If you want to go deeper on platform-specific filtering behavior, the guide on sorting and filtering on Mac covers that in detail.

Common Mistakes When Clearing and Reapplying Filters in Excel

The most expensive mistake is clicking the Filter button when you meant to click Clear. They sit next to each other on the ribbon, and toggling AutoFilter off wipes your dropdowns. You haven't lost your data, but you've lost your filter setup, and rebuilding it is annoying. The Filter button is for turning AutoFilter on or off; Clear is for resetting criteria while keeping the structure intact.

Second: forgetting to hit Reapply after adding rows. If your filter was showing Q1 orders and you just entered fifteen new Q1 rows, those rows won't appear until you hit Reapply. This is the root cause of most "Excel filter not showing all data" questions.

The hidden-row trap is the sneaky one. If Clear All Filters runs and your row count still looks wrong, check whether rows were manually hidden before you got the file. Right-click on the row numbers around the gap and look for Unhide.

Open a spreadsheet you're already working with and practice clearing and reapplying a filter before you need to do it under pressure. The muscle memory matters more than you'd think.