unlock

How to Clear or Remove Filter in Excel

0:00
Toggle fullscreen Fullscreen button

Welcome!

In the previous tutorial you could see how to create a filter in Excel.

Today, we’ll have a look at how to clear or completely remove filter from a table.

Ready to start?

Hello! And welcome to EasyClick Academy!

My name’s Frank and together with our EasyClick team,

we’re here to make sure you’ll be able to use Excel in a quick and easy way,

thanks to our digestible video tutorials.

First, we need to have a look at how to spot quickly that a filter is ‘on’ in one of the columns.

Then, we’ll go through how to clear or completely remove the filter from the table.

Let’s start from step one.

If some information has been filtered out in one of the columns,

you’ll recognise it by spotting a small ‘funnel’ icon in one of the drop-down buttons.

The basics of how to use a filter were shown in the previous video tutorial on how to create a filter in Excel.

So here, we can see the already applied filter in the columns ‘Days’ and ‘Season’.

There’s nothing similar in the column ‘Month’, which means that in that column,

no data have been filtered out.

Well, we’ll carry on now and see how to clear filter in the table.

And as usual, there’s more than one way to do that.

The first way is to use one click to clear the filter from all columns in the table at once.

Go to ‘Data’ tab, section ‘Sort & Filter’, and find and click on ‘Clear’.

All filters from the table will be cleared in one click and all data will be visible again.

The other way is convenient if you want to clear the filter column by column,

not to clear it from the whole table at once.

We’ll undo the last changes to turn the filter back on again,

and we’ll go step by step through the whole procedure.

If you want to clear the filter column by column,

you’ll need to click on each drop-down button one by one and click on the option ‘Clear Filter From’,

which will turn the filter off in each column individually.

You can use this ‘column-by-column’ way to turn off all active filters in the table.