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 · 81035 Viewers
80 Video lessons · 133065 Viewers
52 Video lessons · 66495 Viewers
59 Video lessons · 52298 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.