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:
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:
Voilà… we’re back to the original spreadsheet:
One Minute Office Magic 