Pinterest Pixel

Clear Filters & Clear Pivot

When working with Pivot Table Filters, there are times wherein you have a lot of filters set... read more

Download Excel Workbook
Bryan
Posted on

Overview

Clear Filters & Clear Pivot | MyExcelOnline Clear Filters & Clear Pivot | MyExcelOnline

When working with Pivot Table Filters, there are times wherein you have a lot of filters set up and it takes time to reset them. Good thing there is a quick way to reset this. And you can also do a similar thing to reset your Pivot Table setup!

In this article, you will be provided with a detailed tutorial on how to:

Download this workbook to follow along with this tutorial on how to clear filters & clear pivot:

download excel workbookClear-Filters-Clear-Pivot.xlsx


Here is our current Pivot Table setup. You can see we have 3 Filters on the top portion.

Clear Filters & Clear Pivot

 

Clear Filters in Pivot

If we open the Sales Person filter, you can see we have items filtered out:

Clear Filters & Clear Pivot

The same goes for the Sales Quarter Filter:

Clear Filters & Clear Pivot

To reset all of the filters in one step, go to PivotTable Analyze > Actions > Clear > Clear Filters

Clear Filters & Clear Pivot

And just like that, all of your filters are now reset! Your Pivot Table shows the updated data as well.

Clear Filters & Clear Pivot

 

Clear Filter using QAT

If you want to avoid multiple clicks, you can even add a clear button in QAT and use it to save time.

To add this button, follow the steps below:

STEP 1: Right-click on the top Ribbon and select Customize Quick Access Toolbar.

Clear Filters & Clear Pivot

STEP 2: On Choose commands from, select All Commands from the drop-down.

Clear Filters & Clear Pivot

STEP 3: Select Clear Filters and click Add >>

Clear Filters & Clear Pivot

STEP 4: Click OK.

Clear Filters & Clear Pivot

Now let us try out the clear button in action!

Clear Filters & Clear Pivot

The filters are now cleared! Adding the button in QAT can make the task simpler and quicker.

Clear Filters & Clear Pivot

 

Clear Pivot Table

What if you want to reset your PivotTable setup? Go to PivotTable Analyze > Actions > Clear > Clear All

Clear Filters & Clear Pivot

Now you can start again with setting up your Pivot Table Fields!

Clear Filters & Clear Pivot

 

If you like this Excel tip, please share it
Clear Filters & Clear Pivot | MyExcelOnline Clear Filters & Clear Pivot | MyExcelOnline
Clear Filters & Clear Pivot | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Connect Slicers to Multiple Excel Pivot Tables

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...