Microsoft Office Tutorials and References
In Depth Information
Changing the Format of a PivotTable
The Report Layout command offers three alternatives for arranging the rows in your report,
as shown here:
● Compact Form This display option has the least amount of clutter. Multiple levels
under a main heading are indented.
● Outline Form Each row label gets its own field header. Each main grouping is on its
own row, with secondary groupings in new rows beneath it in a column to the right
of the previous level. Subtotals can appear at the top or bottom of each group.
● Tabular Form All data is in a grid, with no indenting. Secondary levels of grouping
begin in additional columns to the right of the main heading. In this format, subtotals
appear only at the bottom of each group, even if you choose the Show All Subtotals
At Top Of Group option.
Figure 12-15 shows the results for each option.
As with ordinary tables, you can apply styles to PivotTables, using the PivotTable Styles
gallery. The procedures for creating, modifying, and applying styles are identical, so we won’t
repeat them here. (See “Formatting Tables with Table Styles” on page 391.) The gallery is much
larger, however, with 84 default styles to choose from instead of the 60 selections in the
Table Styles gallery.
You’ll see the reason for the difference when you duplicate and customize a PivotTable
style. In the Modify PivotTable Quick Style dialog box, you’ll find 25 individual options for a
PivotTable style; that’s nearly double the number of options in a regular table style,
reflecting the need for separate formats to cover subtotals and grand totals, header cells,
subheadings, and other features found only in PivotTables.