Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 PivotTable and then on the Options contextual tab click the Clear button and then click Clear Filters.
Doing so removes every active filter in the PivotTable. When you're done with the filter, simply remove it and continue with the rest of your work. You can always re-create the filter or if you haven't many changes you don't want to lose you can also use Ctrl+Z or the Undo button to bring the filter back.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64729 Viewers
80 Video lessons · 124331 Viewers
52 Video lessons · 60260 Viewers
59 Video lessons · 46099 Viewers