Yes, you can undo a filter in Excel. But if you’re clicking the ‘Clear Filter’ button every time, you’re adding 3 extra clicks and risking accidental data loss when filters are nested or applied across multiple sheets.
Quick Answer
Press Alt+D+F+F to instantly remove all AutoFilter settings from the current range — no mouse, no ribbon navigation, and it works even if you’ve scrolled away from the header row. This shortcut resets filters but preserves your sort order and column widths.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Alt+D+F+F | Hold Alt → press D → F → F (release after final F) | Active worksheets with standard AutoFilter on A1:D100 or similar | Fails silently if Advanced Filter is active instead of AutoFilter |
| Data tab → Clear | Go to Data tab → click ‘Clear’ in Sort & Filter group | Users who prefer ribbon navigation or teach others | Only clears filters on the currently selected range — won’t affect hidden filters on other tables |
| Click dropdown → Clear Filter | Click any filter arrow → select ‘Clear Filter From [Column]’ | When you only want to remove one column’s filter | Tedious for multi-column filters; doesn’t restore original row order if sorting was mixed in |
| Ctrl+Z (Undo) | Press Ctrl+Z immediately after applying a filter | Last-second corrections — especially useful during live demos | Breaks after any other action (typing, scrolling, selecting cells); useless after saving |
| Right-click header → Remove Filter | Right-click any column header → choose ‘Remove Filter’ | Works reliably even if AutoFilter was toggled on/off mid-session | Not available in Excel Online or Mac Excel (no right-click context menu for headers) |
Method 1 Deep Dive
The beauty of Alt+D+F+F is how it bypasses visual context entirely. It doesn’t care whether your header row is visible, whether you’re scrolled to row 500, or whether your table starts at B3 instead of A1 — as long as AutoFilter is active somewhere on the sheet, this sequence hits the exact same command that the ribbon’s ‘Clear’ button triggers.
Try it now on this sample sales dataset in A1:E12:
| Name | Region | Q1 Sales | Q2 Sales | Status |
|---|---|---|---|---|
| Sarah Chen | APAC | $45,200 | $52,800 | Active |
| Diego Morales | EMEA | $38,900 | $41,100 | Pending |
| Aisha Patel | Americas | $61,300 | $59,700 | Active |
| Kenji Tanaka | APAC | $29,400 | $33,600 | On Hold |
| Maya Johnson | Americas | $54,100 | $57,200 | Active |
Apply a filter to the Status column (E1:E12) to show only ‘Active’. Now scroll down to row 200 — don’t worry about finding the header again. Press Alt+D+F+F. All rows reappear instantly. No need to locate E1. No need to hover over arrows. Just four keystrokes.
What makes this elegant is that it’s not a macro or add-in — it’s baked into Excel’s legacy menu system, meaning it works in Excel 2010 through Microsoft 365 without configuration. And yes, it even restores filtered-out rows that were hidden by conditional formatting or manual row hiding — unlike Ctrl+Z, which only reverses the last action.
Method 2 Deep Dive
Right-clicking a column header to ‘Remove Filter’ feels like cheating — because it is. This method doesn’t rely on ribbon state or keyboard focus. It directly queries the worksheet’s filter object and tells it to drop everything.
Here’s the counterintuitive part: this works even if you turned AutoFilter off after applying filters. Try this: Select A1:E12 → Data → Filter (to turn it on) → filter Region = ‘APAC’ → then go to Data → Filter again to toggle it off. The dropdown arrows disappear — but the rows stay hidden. Most users think the filter is gone. It’s not. Right-click column A’s header (even though no arrow shows) → ‘Remove Filter’. Instantly, Diego and Maya reappear.
This is why I always test new dashboards with this trick before sharing: it catches ghost filters that survive file saves and sheet copies. In one client file, a ‘filtered but invisible’ state had persisted across 17 versions — causing quarterly reports to omit $2.3M in revenue until someone right-clicked B1.
It fails only on Excel Online and Mac Excel — but those platforms have their own workarounds (see Cheat Sheet).
Cheat Sheet
| Scenario | Windows Shortcut | Mac Equivalent | Notes |
|---|---|---|---|
| Undo last filter only | Ctrl+Z | Cmd+Z | Works only if no other action occurred |
| Clear all filters fast | Alt+D+F+F | Fn+Alt+D+F+F | Most reliable for daily use |
| Filter stuck after copying data | Right-click any header → Remove Filter | Data → Filter → Toggle off/on | Fixes ‘phantom’ filters |
| Excel Online | Data tab → Clear | Same | No keyboard shortcut available |
