Microsoft Office Tutorials and References
In Depth Information
See Also For more information on creating conditional formats, see “Changing the
Appearance of Data Based on Its Value” in Chapter 4, “Changing Workbook Appearance.”
In Excel, you can take full advantage of the Microsoft Office system enhanced formatting
capabilities to apply existing formats to your PivotTables. Just as you can create Excel
table formats, you can also create your own PivotTable formats to match your
organization’s desired color scheme.
To apply a PivotTable style, click any cell in the PivotTable and then, on the Design
contextual tab, in the PivotTable Styles group, click the gallery item representing the style
you want to apply. If you want to create your own PivotTable style, click the More button
in the PivotTable Styles gallery (in the lower-right corner of the gallery), and then click
New PivotTable Style to display the New PivotTable Quick Style dialog box.
Type a name for the style in the Name field, click the first table element you want to
customize, and then click Format. Use the controls in the Format Cells dialog box to change
the element’s appearance. After you click OK to close the Format Cells dialog box, the New
PivotTable Quick Style dialog box Preview pane displays the style’s appearance. If you want
Excel to use the style by default, select the Set As Default PivotTable Quick Style For This
Document check box. After you finish creating your formats, click OK to close the New
PivotTable Quick Style dialog box and save your style.