Microsoft Office Tutorials and References
In Depth Information
Formatting the Pivot Report—Values and All
Figure 8–60. And we’ve certainly seen THIS one before; the good old Number tab, here used by PivotTables
Then make your selection as per the formatting instructions in Chapter 4. Note that right-clicking
on any one value and selecting the appropriate format affects all the data in that field. You can also
arrive at the Value Field Settings dialog box by clicking PivotTables Tools Options Summar i ze
Values By More Options .
You can introduce report-wide format changes by clicking PivotTable Tools Design tab
PivotTable Styles (drop-down arrows). These selections emulate the table-wide formats available for
standard Excel Tables (Figure 8–61):
Figure 8–61. Setting the table: PivotTable style options
Just click one. And you have the same Banded Rows/Banded Columns options you’re presented
with in the standard table styles.
The Grand Totals option on the Design tab allows you to remove the pivot report grand totals that
appear by default, as well as institute Grand Totals for rows, applying to data that reads across
col umn s. You ca n a l so se l e ct a n y r a n g e of ce l l s a n d uti l i ze Exce l ’ s compl e me n t of ba si c for ma tti n g
embellishments; including that context menu you’ve seen before (Figure 8–62):
 
Search JabSto ::




Custom Search