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




Custom Search