Remove a filter to show all rows and columns again

When you have filtered a spreadsheet in Excel, the rows that don't match your filter criteria disappear from view — but they're still there. To see everything again, you turn off the filter. The fastest way is to click the Data tab at the top, then click Clear in the Sort & Filter group. This removes all active filters at once and shows every row and column in your spreadsheet.

If you want to keep the filter buttons visible but just show all the data temporarily, you can click the filter dropdown arrow on any column header and select Clear Filter From [Column Name]. This removes the filter from that one column only, while leaving filters on other columns in place.

The method you choose depends on whether you plan to filter again soon. Clearing the filter completely removes it, so you'd have to set it up again if you need it later. Clearing a single column's filter keeps your other filters active, which is useful if you're working with multiple filters at once.

Key Takeaways

  • Click the Data tab, then Clear to remove all filters from your spreadsheet at once.
  • Click the dropdown arrow on a column header and select Clear Filter From [Column Name] to remove the filter from just that column.
  • Clearing a filter shows all rows again but does not delete any data — the hidden rows were always there.
  • If you remove a filter by mistake, you can undo it when ready by pressing Ctrl+Z (or Cmd+Z on Mac).

The difference between clearing a filter and deleting filtered rows

A common worry is that clearing a filter will delete the rows you filtered out. It will not. When you filter data in Excel, you are only hiding rows that don't match your criteria. The data itself stays in the spreadsheet. Clearing the filter straightforward makes those hidden rows visible again.

If you actually want to delete rows — not just hide them — you have to select them manually and use the Delete command. Clearing a filter never removes data from your file. This is why filtering is safe to use when you're organizing files: you can filter to focus on one part of your data, work with it, and then clear the filter to see the whole picture again.

How to clear filters on specific columns without affecting others

If your spreadsheet has filters on multiple columns and you only want to remove the filter from one of them, click the dropdown arrow in that column's header. A small menu appears with options like Sort A to Z, Sort Z to A, and Clear Filter From [Column Name]. Click the clear option to remove just that filter.

The other columns keep their filters active. This is useful when you've filtered by date range and category, for example, and you want to see all dates but keep the category filter in place. You can clear filters one at a time without touching the rest of your setup.

What to do if the clear button is grayed out

If you click the Data tab and the Clear button appears grayed out (disabled), it means no filter is currently active on your spreadsheet. This can happen if you've already cleared all filters, or if the data was never filtered in the first place. Check whether the column headers have dropdown arrows — if they don't, filtering is not turned on.

To turn filtering back on, click any cell in your data range, then click the Data tab and select Filter. Dropdown arrows will appear in the header row, and you can set up filters again. If the dropdown arrows are there but the Clear button is still grayed out, it means the filter buttons are visible but no actual filter is applied — you can click a dropdown and set one up whenever you need it.

Clearing filters when you have frozen rows or columns

If you've frozen rows or columns to keep headers visible while scrolling, clearing a filter works the same way. Click Data, then Clear, and all filters disappear. The frozen rows or columns stay frozen — freezing and filtering are separate features and don't affect each other.

The only thing to watch for is that if you've filtered your data and then frozen rows, clearing the filter will show all the previously hidden rows at once. This can make your spreadsheet longer than you expected. If that happens and you want to re-explore the filter, you can undo the clear action with Ctrl+Z and set the filter up again.

Using AutoFilter versus manual filtering

Excel has two main ways to filter: AutoFilter, which adds dropdown arrows to your headers automatically, and manual filtering, where you set up filters through the Data menu. Both work the same way when you clear them — click Data, then Clear. The method you used to create the filter doesn't matter; the clear command removes it either way.

AutoFilter is the most common approach because the dropdown arrows are straightforward to see and use. If you're not sure which type of filter you have, look at your column headers. If they have small dropdown arrows, you're using AutoFilter. If they don't but you know a filter is active, you set it up manually through the Data menu. Either way, the Clear button will remove it.

Frequently Asked Questions

Will clearing a filter delete my data?

No. Clearing a filter only hides or shows rows — it never deletes anything. All the data you filtered out is still in your spreadsheet; it's just hidden from view. When you clear the filter, those rows become visible again.

Can I undo a filter I just cleared?

Yes. Press Ctrl+Z (or Cmd+Z on Mac) when ready after clearing the filter, and Excel will restore it. This works as long as you haven't made other changes to the spreadsheet since you cleared it. If you've made several changes, undo will step back through all of them.

How do I clear a filter on just one column?

Click the dropdown arrow in that column's header and select Clear Filter From [Column Name]. This removes the filter from only that column while keeping filters on other columns active.

What if I can't see the filter dropdown arrows?

Click any cell in your data, then go to the Data tab and click Filter. This turns on AutoFilter and adds dropdown arrows to all header cells. If the arrows still don't appear, make sure your header row is actually the first row of your data range.

Can I clear filters from multiple sheets at once?

No. You have to clear filters on each sheet separately. Click the sheet tab at the bottom, then go to Data and click Clear. Repeat for each sheet that has filters you want to remove.