Join Curt Frye for an in-depth discussion in this video Clearing and reapplying PivotTable filters, part of Excel for Mac 2016: Pivot Tables in Depth.
- [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,…
Author
Curt Frye
Released
3/19/2016- Name the option you use to limit the data that appears in a PivotTable.
- Explain how to create a PivotTable after clicking a cell in the data set.
- List the steps needed to see the sum of reservations on a PivotTable.
- Recall how to return all the data to the body of a PivotTable.
- Name the contextual menu that allows you to create new PivotTable style.
- Determine the category of the Format Cells dialog that lets you change the decimal places and the money symbol.
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 16s
-
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables3m 6s
-
Creating a PivotTable3m 12s
-
Pivoting a PivotTable2m 57s
-
Configuring a PivotTable3m 51s
-
Managing PivotTables4m 16s
-
-
2. Summarizing PivotTable Data
-
Creating a calculated field3m 13s
-
3. Sorting and Filtering PivotTable Data
-
Sorting PivotTable data3m 15s
-
Formatting slicers3m 44s
-
-
4. Formatting and Printing PivotTables
-
Applying a PivotTable style3m 30s
-
Creating a PivotTable style4m 32s
-
Printing a PivotTable3m 18s
-
-
5. Applying Conditional Formats to PivotTables
-
Conclusion
-
Next steps1m 46s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Clearing and reapplying PivotTable filters