Reapply Filters Excel: Every Method Ranked (2026)

You add 15 new rows to your dataset, glance at your filtered view, and wonder why the numbers still look wrong. Sound familiar? Excel's AutoFilter doesn't live-update. The moment your underlying data changes — new rows, edited values, deleted records — your filter criteria stay frozen on what the data looked like when you last applied them. That gap between "what the filter shows" and "what the data actually says" is where reporting errors are born.

After 12+ years of building operational dashboards under real deadlines (including a logistics dashboard that's been in production for three years and saves about 12 hours of manual work weekly), I've watched this exact problem burn people who had no idea it was happening. This article covers three fixes ranked by complexity: manual reapply via the ribbon and keyboard shortcut, VBA automation, and the behavioral difference between Excel Tables and plain ranges that trips up almost everyone before they reach for VBA at all.

The Reapply button on the Data tab is the fastest manual fix when filtered data falls out of sync.

The Quick Distinction: Reapply vs. Clear vs. Remove

Reapply re-runs your existing filter criteria against the current data without changing what you're filtering for. Clear removes the active filter results but leaves the AutoFilter dropdowns in place. Remove (or "Turn off AutoFilter") strips the dropdowns entirely. Most people accidentally hit Clear when they mean Reapply, then spend five minutes wondering why everything is showing again. Keep that distinction sharp and you'll avoid half the frustration this feature causes.

Step 1: Reapply Filters in Excel Manually Using the Ribbon or Keyboard Shortcut

Once you know a reapply is needed, the fix takes about two seconds. The ribbon route is the same whether you're on Windows or Mac, and it's the method I'd recommend for anyone who doesn't reapply filters often enough to justify memorizing a shortcut.

The Ribbon Route (Windows and Mac)

1. Select any cell inside your data range. Excel needs to know which AutoFilter you're working with.
2. Open the Data tab on the Excel ribbon.
3. In the Sort & Filter group, click Reapply.

Excel re-evaluates your filter criteria against every row currently in the dataset. On Mac, the button is in the same location (Data tab, Sort & Filter group) and behaves identically. If you're on sorting and filtering on Mac, the full workflow including sort behavior differences is worth reviewing before you go further.

Keyboard Shortcuts to Reapply Filters Fast

On Windows, the reapply filter shortcut in Excel is Alt → A → Y2, pressed sequentially, not simultaneously. It's not elegant, but it works across Excel 2016, 2019, and 365.

Mac users don't have a native equivalent. The workaround is to assign a custom keyboard shortcut via Tools → Customize Keyboard, pointing it to the Reapply command. Annoying to set up once, but worth it if you're running filters constantly.

Step 2: Understand Why Tables Reapply Filters Differently Than Plain Ranges

Before you jump to VBA, there's a behavioral split worth understanding because it changes whether automation is even necessary for your situation.

When your data is formatted as an Excel Table (Ctrl+T to convert), both filter criteria and sort order are saved with the workbook. Close it, reopen it, and your filter is exactly where you left it. Plain ranges behave differently: filter criteria are saved, but sort order is not. That sort you applied before closing? Gone on reopen, silently, with no warning.

Tables also auto-expand when you add rows below them. A plain range doesn't. So if your filter is sitting on an unstructured range and you add 20 rows at the bottom, those rows are invisible to the filter — not because the filter is broken, but because it was never told those rows existed. That's not a filter problem. That's a range problem.

Converting to a Table with Ctrl+T fixes this permanently. Skipping this step and reaching straight for VBA is the wrong move for most people — it patches over a structural issue instead of fixing it.

Step 3: Automatically Reapply Filters in Excel Using a VBA Macro

If you've converted to a Table and the manual reapply is still too slow for your workflow — or you're maintaining a workbook other people use and can't trust them to remember the reapply step — VBA automation is the right tool. A solution that requires the user to remember a manual step is a design failure. This is how you remove that dependency.

The Worksheet_Change Event: What to Paste and Where

Open the VBA editor with Alt+F11 on Windows (Fn+Opt+F11 on Mac). In the Project pane on the left, double-click the sheet where your data lives — not a module, the sheet itself. Paste this:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Me.AutoFilter.Range) Is Nothing Then
        Me.AutoFilter.ApplyFilter
    End If
End Sub

This fires every time a cell changes on that sheet. If the change falls inside the AutoFilter range, it triggers a reapply. No button needed, no shortcut to remember. This syntax works in Excel 2016, 2019, and 365.

Performance Warning for Large Datasets

Every cell edit fires this macro. On a dataset with 500 rows, that's invisible. On 50,000 rows with complex filter criteria, you'll feel it.

If your workbook is large, wrap the macro with Application.ScreenUpdating = False at the top and True at the bottom to reduce flicker, and consider adding a row-count check so the macro only fires when the dataset is below a threshold you're comfortable with. Any VBA solution that a replacement hire can't maintain or disable without breaking something fails the only test that matters for shared workbooks.

For Excel 365 users who want filters to update dynamically without VBA, the FILTER function is worth serious consideration. It returns results that update live as your data changes — no macro, no manual reapply. The trade-off is that it outputs to a separate range rather than filtering in place, which doesn't suit every layout. For reporting dashboards in 2026, it's often the cleaner path.

Common Mistakes When You Reapply Filters in Excel

The most common stumble: people reapply a filter and still can't find rows they know are there. Nine times out of ten, the filter criteria are stacked — a second filter was applied on top of the first without clearing, and now the view is over-filtered. Reapply refreshes criteria; it doesn't reset them. If your results look too narrow, check every column header for an active filter icon before assuming the data is wrong.

The silent one — the one that actually hides rows with no obvious indication — is a blank row inside your dataset. A blank row tells Excel the data has ended. Everything below it becomes invisible to the AutoFilter. The fix is simple: check for common data errors like blank rows and trailing spaces before setting up any filter, automated or otherwise. Trailing spaces cause the same class of problem: a cell that looks like "Chicago" and a cell that reads "Chicago " (with a trailing space) are not the same to a filter, and the mismatch will exclude rows silently.

If you're newer to how filters work in Excel and want to understand the foundational mechanics before tackling the automation layer, the Excel for beginners guide covers everything that makes this easier to follow.