Formatting PivotTables
Formatting PivotTables is very much like formatting ranges as tables. You get a separate set of PivotTable Styles, which you can create and customize almost exactly as you can Table Styles in Excel. The only difference is that, with PivotTable Styles, you can create custom formatting for additional table elements, such as Subtotal and Grand Total rows and columns, as well as Page Field Labels and Values (which refer to fields added to the Report Filter area of the table).
Access PivotTable Styles on the PivotTable Tools Design tab. Notice also that this tab includes style options for displaying row and column headers as well as banded rows and columns, similar to Table Style options.
For more details on creating and working ...
Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
