Microsoft Office Tutorials and References
In Depth Information
Editing PivotTables
In this exercise, you’ll rename a PivotTable, specify whether subtotal and grand total rows
will appear, change the PivotTable summary function, display each cell’s contribution to its
row’s total, and create a formula that incorporates a value in a PivotTable cell.
SET UP You need the Editing workbook located in the Chapter10 practice file folder
to complete this exercise. Open the workbook, and then follow the steps.
1
On the PivotTable worksheet, click any cell in the PivotTable.
2
On the Analyze tool tab, click the PivotTable button and then, in the PivotTable
Name field, enter VolumeSummary and press Enter to rename the PivotTable.
3
On the Design tool tab, in the Layout group, click Subtotals , and then click Do Not
Show Subtotals . Excel removes the subtotal rows from the PivotTable.
4
On the Design tool tab, in the Layout group, click Grand Totals , and then click On
for columns only . Excel removes the cells that calculate each row’s grand total.
Search JabSto ::

Custom Search