Microsoft Office Tutorials and References
In Depth Information
Editing PivotTables
5
On the Quick Access Toolbar , click the Undo button to reverse the last change.
6
Right-click any data cell in the PivotTable, point to Summarize Values By , and then
click Average to change the Value field summary operation.
7
On the Quick Access Toolbar , click the Undo button to reverse the last change.
8
Right-click any data cell in the PivotTable, and then click Value Field Settings to
open the Value Field Settings dialog box.
9
Click the Show Values As tab to display the Show Values As page.
10
10
In the Show Values As list, click % of Row Total .
11
Click OK to change how Excel calculates the values in the PivotTable.
Search JabSto ::




Custom Search