Clearing all filters with a single click in Excel

One of my colleagues at work wondered if there was an easy way to clear out multiple column filters in Excel without having to go into each column separately. A quick search on Google showed that you definitely can do that…

Here I have a sample spreadsheet with random letters and numbers. I’m going to place a filter for the letter “a” in the first column and a filter for the number “2” in the second column:

excel-clearfilters-20170906-1

I now have two column filters that reduced the number of rows from 11 to 2. Now if I want to remove all the filters at once, I can click on Data > Clear:

excel-clearfilters-20170906-2

Voilà… we’re back to the original spreadsheet:

excel-clearfilters-20170906-3

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s