Microsoft Office Tutorials and References
In Depth Information
Apply a PivotTable Quick Style
Chapter 6: Analyzing Data with PivotTables
The Quick Styles gallery
Note: When you hover the mouse
pointer over a style, Excel
temporarily formats the PivotTable
with that style.
4 Click the Quick Style you
want to apply.
● Excel applies the Quick
You may find that none of the predefined PivotTable Quick Styles give you the exact
look that you want. In that case, you can define that look yourself by creating your own
custom PivotTable Quick Style.
There are 25 separate PivotTable elements that you can format. These elements include
the entire table, the page field labels and values, the first column, the header row, the
Grand Total row, and the Grand Total column.
Click the Design tab, click the drop-down arrow to display the PivotTable Styles gallery,
and then click New PivotTable Style. In the New PivotTable Quick Style dialog box, type
a name for your custom Quick Style. For each element you want to format, click the
element, click Format, use the Format Cells dialog box to select the formatting you want
to use, and then click OK.