Microsoft Office Tutorials and References
In Depth Information
Formatting PivotTables
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 tool tab,
in the PivotTable Styles group, click the style that you want to apply. If you want to create
your own PivotTable style, click the More button to display a menu containing a gallery, and
then click New PivotTable Style below the gallery to open the New PivotTable Style dialog
box.
10
Enter 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 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.
Search JabSto ::




Custom Search