Clearing and reapplying PivotTable filters

- [Voiceover] There would be little sense in applying…a pivot table filter if you weren't able to remove it later.…In Excel 2016 you can remove filters from individual fields,…remove all filters at the same time,…and reapply filters you just got rid of.…I will show you how to remove and reapply filters.…My sample file is the Clearing workbook…and you can find it in the chapter three folder…of your exercise files collection.…This workbook contains a pivot table…that already has two filters applied.…I have filtered the room type field,…so that only Westminster's displayed.…

And also I have filtered by year…so that only 2014 is displayed.…If I want to clear a specific filter…then I can click the labels button's down arrow,…in this case I'll click Column Labels.…That displays a dialog box for that field.…I want to clear the filter for room type…so I'll click Clear Filter…and close the room type dialog box…and there we have it.…Now let's say that I want to clear all filters…from a pivot table.…

In this case there's only one,…