Quickly Clear Filters in Excel

If you frequently use filters in your pivot tables, here is a quick way to clear them. Thanks to AlexJ, who shared this tip. You can find more of AlexJ’s Excel sample files on my Contextures site.

If you use the Ribbon commands to clear a pivot table’s filters, it takes several clicks. First, you go to the Analyze tab under PivotTable Tools, then click Actions, and then click Clear Filters.

clearfilterqat02

Add a Clear Button

To make this a one-click process, you can add a Clear button to the Quick Access Toolbar (QT). Then, select a cell in a pivot table, or an Excel table, click the button, and all the filters are cleared.

clearfilterqat01

Video: Quickly Clear Pivot Table Filters

Watch this short video to see the steps for setting up the button, and clearing the filters.

Or watch on YouTube: Quickly Clear Filters in Excel Tables and Pivot Tables

More on Pivot Filters

For more information on pivot table filters, please click here to visit my Contextures website.

______________________

This entry was posted in Sort and Filter. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *