How to Remove a Filter in Excel (And When Each Method Makes Sense)

Filters are one of Excel's most useful features — they let you hide rows that don't match your criteria so you can focus on exactly the data you need. But once you're done analyzing, you'll want to bring all your data back into view. Knowing how to remove or clear filters correctly — and understanding the difference between the two — saves you from confusion and prevents accidental data loss.

The Difference Between Clearing a Filter and Removing It

This distinction matters more than most people realize.

Clearing a filter turns off the active filtering criteria on one or more columns, bringing all hidden rows back into view. The filter dropdowns (the small arrows in the header row) remain in place, ready to use again.

Removing a filter takes those dropdown arrows away entirely, turning off the AutoFilter feature for the entire sheet or table.

Neither action deletes your data. Both are reversible. But choosing the wrong one can leave you confused — for example, if you clear a column filter but forget there's still an active filter on another column, some rows will still be hidden.

How to Clear a Filter on a Specific Column

If you only want to reset filtering on one column without affecting others:

1. Click the dropdown arrow on the column header that has an active filter (it looks like a funnel icon when a filter is active)
2. Select "Clear Filter From [Column Name]"
3. All hidden rows for that column will reappear

This is the right move when you're working with multi-column filters and only want to reset one variable at a time.

How to Clear All Filters at Once 🔄

To remove all active filter criteria across the entire sheet in one step:

1. Go to the Data tab in the ribbon
2. Click "Clear" (in the Sort & Filter group)

Every hidden row returns to view. The dropdown arrows stay in your headers, so your filter setup is preserved — just reset.

You can also do this from the Home tab by going to Sort & Filter > Clear.

How to Remove AutoFilter Entirely

If you want to remove the filter dropdowns from the header row altogether:

1. Click anywhere inside your data range
2. Go to Data > Sort & Filter
3. Click "Filter" to toggle it off

The arrows disappear, and all rows become visible again. To bring the filter back later, just click "Filter" again — Excel re-applies it to the same range.

Keyboard shortcut: Ctrl + Shift + L toggles AutoFilter on and off. This works whether you're turning filters on for the first time or removing them entirely.

Filters in Excel Tables vs. Regular Data Ranges

The behavior differs slightly depending on how your data is structured.

If your data is formatted as an Excel Table (inserted via Insert > Table or Ctrl+T), the filter dropdowns are a built-in feature of that format. You can clear filter criteria, but removing the arrows entirely requires converting the table back to a normal range first (Table Design > Convert to Range).

When Filters Seem Stuck or Data Still Looks Hidden

Sometimes rows appear to be missing even after you've cleared filters. A few things worth checking:

• Another column still has an active filter — look for the funnel icon on any header. If even one column is filtered, rows can be hidden.
• Rows are manually hidden — this is separate from filtering. Manually hidden rows won't reappear when you clear filters. To reveal them, select the rows around the hidden section, right-click, and choose "Unhide."
• Grouped rows are collapsed — Excel's row grouping feature can also hide rows. Look for the small + or – symbols on the left side of the sheet.
• Sheet view or workbook-level settings — in shared workbooks using Sheet Views, filters applied in one view won't affect other views.

Removing Filters in Excel on Mac vs. Windows

The steps are nearly identical across platforms. The Data tab and the Ctrl+Shift+L shortcut (Command+Shift+F on some Mac versions) both work in Excel for Mac. The ribbon layout is slightly different visually, but the Sort & Filter group contains the same Filter and Clear buttons.

In Excel for the web (the browser-based version), filter functionality is more limited. You can clear filters from the Data tab, but some advanced filter options available in the desktop app may not appear.

What Determines How This Works for You

The exact steps and behavior depend on several factors that vary by user:

• Excel version — Microsoft 365, Excel 2021, 2019, 2016, and earlier versions have subtle UI differences
• Desktop vs. web vs. mobile — the web and mobile versions have reduced filter controls
• Data structure — whether your data is in a Table, a named range, or an unformatted range changes what options are available
• Shared workbooks or co-authoring — filter changes may behave differently in collaborative editing contexts
• Whether macros or pivot tables are involved — filtered data connected to pivot tables or controlled by VBA macros operates under different rules

The core concepts — clear vs. remove, column-level vs. sheet-level, AutoFilter vs. Table filters — apply universally. But how those tools surface in your specific version of Excel, and which approach fits your workflow, depends on what you're working with.