Pinterest Pixel

Clear Filters & Clear Pivot

Bryan
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!
Clear Filters & Clear Pivot | MyExcelOnline Clear Filters & Clear Pivot | MyExcelOnline

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
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  Pivot Filter by Values - Top or Bottom %

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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