Microsoft Office Tutorials and References
In Depth Information
Editing PivotTables
15
Click OK to apply the filter.
16
On the Analyze tool tab, click the Actions button, click Clear , and then click Clear
Filters to remove all filters from the PivotTable.
CLEAN UP Close the Focusing workbook, saving your changes if you want to.
Editing PivotTables
After you create a PivotTable, you can rename it, edit it to control how it summarizes your
data, and use PivotTable cell data in a formula. As an example, consider a PivotTable named
PivotTable2 that summarizes package volumes for every Consolidated Messengers regional
distribution hub.
10
Search JabSto ::




Custom Search