Microsoft Office Tutorials and References
In Depth Information
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_start workbook located in your Chapter09 practice
file folder to complete this exercise. Open the Editing_start workbook, and save it
as Editing . Then follow the steps.
1. On the Sheet2 worksheet, click any cell in the PivotTable.
2. On the Options contextual tab, in the PivotTable group, in the PivotTable Name
field, type VolumeSummary and press Enter .
Excel renames the PivotTable.
3. On the Design contextual 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 contextual 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