Clearing and reapplying PivotTable filters

You can limit the data that appears in a PivotTable by applying a filter.…But there would be little sense in applying a filter if you weren't able…to remove it later.…In Excel you can remove filters from individual fields, remove all filters at…the same time, and reapply filters you just got rid of.…So for example in this PivotTable here, I have filters applied to the Year and Month fields.…So let's say that I want to clear the filter from the Year field.…To do that I can go into the PivotTable Field List, click the downward-…pointing black triangle at the right edge of the Year field header and then…click Clear Filter From Year.…

When I do, Excel removes the filter.…Now let's say that I want to bring the filter back.…Well I could either recreate the filter or I could use the Undo feature.…To do that I'll go up to the Quick Access Toolbar and click the Undo button and…when I do Excel reapplies the filter.…Now let's say that you have filters in many fields of your PivotTable and you…want to remove them all at one time. To do that, click any cell in the on the…