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 WORKBOOK


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

Clear Filters & Clear Pivot | MyExcelOnline

 

Clear Filters in Pivot

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

Clear Filters & Clear Pivot | MyExcelOnline

The same goes for the Sales Quarter Filter:

Clear Filters & Clear Pivot | MyExcelOnline

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

clear filters

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

Clear Filters & Clear Pivot | MyExcelOnline

 

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 | MyExcelOnline

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

Clear Filters & Clear Pivot | MyExcelOnline

STEP 3: Select Clear Filters and click Add >>

Clear Filters & Clear Pivot | MyExcelOnline

STEP 4: Click OK.

Clear Filters & Clear Pivot | MyExcelOnline

Now let us try out the clear button in action!

Clear Filters & Clear Pivot | MyExcelOnline

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

Clear Filters & Clear Pivot | MyExcelOnline

 

Clear Pivot Table

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

Clear Filters & Clear Pivot | MyExcelOnline

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

Clear Filters & Clear Pivot | MyExcelOnline

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 101 Best Excel Tips & Tricks:

Clear Filters & Clear Pivot | MyExcelOnline

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn