Quickly Clear Filters in Excel Tables and Pivot Tables
If you frequently use filters in Excel, here is a quick way to clear them. Instead of using extra clicks to go to the Data tab, and click the Clear command, add a Clear button to the Quick Access Toolbar.
There is a surprising benefit to adding this button -- it also clears all the filters in a pivot table too. Just select a pivot table where one or more filters have been applied, then click the Clear button.
All the filters are removed, saving several steps compared to using the Clear Filters command on the Analyze tab on the Ribbon.
Visit my Contextures site for more tips on Excel pivot table filters.
https://www.contextures.com/excel-piv...