PivotTable: Styles

A PivotTable can be formatted with Styles.

Before You Begin:
Select the PivotTable. The PivotTable Tools should be available.

1. Try it: Format the PivotTable Style

Go to PivotTable Tools ->Design.

Go to PivotTable Styles.

Select: Pivot Style Medium 3.


What Do You See? The PivotTable Styles formatted the Column Headers (Sum of Amount, Category, Product)  as well as the Row Headers (Corporate, Educational, etc.)


Keep going...

PivotTable Tools ->Design-> PivotTable Styles->Style

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: PivotTable Style Options