How to Clear All Filters in Excel in 1 minute (2023)
If I tell you half of Excel users come to Excel to use the filters and advanced filter offered by it, how would you react?
Well, that’s true. Excel filters are simply amazing. It helps you sift through your data in all possible dimensions🚀
However, once applied, how do you clear filters from your data to bring it back to its original shape? You can do that in under 1 minute.
Download our free sample workbook for this guide here to learn with us how!👇
Table of Contents
Clear all filters in Excel
Filters in Excel can spread across various columns. For example, in the image below, we have sales of different products for different months.
Let’s quickly apply filters to it to sort out only the sales for:
- Smartphones and Laptops
- For January and February
So here we go!
We have applied filters to two columns of the sheet i.e., Products and Months.📝
Now, can we readily remove all these filters from our sheet? Here’s how you can do it.
- Go to the sheet where the filters are applied.
- Go to the Data Tab > Clear Filter button.
And there you go! All filters from the sheet have been removed.
We are back to how the data originally looked like👀
Here’s something for you to note. By clearing the filters, we have only removed the applied filter settings from the data set.
But the filters are still there – this is evident from the dropdown arrow button next to the column headers😵
To remove the filters from the dataset altogether:
- Go to the Data Tab > the Filer Icon.
Clicking on this icon will remove filters from the sheet altogether.
See? No more dropdown arrows there✌
Clear single filtered column in Excel
Continuing with the same example as above.
This time, let’s try removing filters from the column “Products” only🧹
To do that:
- Go to the relevant column (Products) in our case.
- Click on the drop-down menu icon on the column header.
The filter menu launches. It clearly shows the products that are selected in the filter, and that are filtered out.
- Click on the option Clear Filter from Products.
And the filter from the column Products will be removed🎭
We can now see the sales for all the products in January and February, only.
This is because the filter is only removed from the column Products. However, the filter applied to the column of Months is still there.
It is only this easy to remove filters from a single column in Excel💁♀️
That’s it – Now what?
The above guide discusses ways how you can remove filters from Microsoft Excel – a single column and from the entire worksheet.
Just like filters, Excel offers so many more features, tools, and functions that’ll leave you jaw-dropped.
Some of the top-notch functions of Excel include the VLOOKUP, SUMIF, and IF functions.
Hop on here and enroll in my 30-minute free email course that will teach you these (and many more) Excel options in a jiffy.
That’s all about removing filters in Excel.
But if you want to learn more about applying filters to Excel, read our blog here.