Microsoft Office Tutorials and References
In Depth Information
l The Format Cells dialog
box appears, displaying
only the Number tab.
8
Click to select
formatting options.
8
8
9
Click OK to close the
Format Cells dialog box.
8
0
Click OK to close the
Value Field Settings
dialog box.
9
0
l Excel recalculates the PivotTable.
l Excel reformats the numbers.
Change It!
In the Design tab Layout group, click Subtotals to
tell Excel whether you want to show subtotals
and whether the subtotals should show at the
top or the bottom of the group. Click Grand
Totals to tell Excel whether you want to show
grand totals for rows and columns, just for rows,
or just for columns
Did You Know?
A cell in a PivotTable may summarize several
rows of information. To view the underlying data
for a cell, double-click it. The rows appear in a
new worksheet. Changes you make to the new
worksheet have no effect on the original data.
Chapter 5: Explore the Patterns in Your Data
117
Search JabSto ::




Custom Search