Excel > Excel 2007 Advanced > PivotTable and PivotCharts

Formatting a PivotTable

Both the data and the look of a PivotTable can be formatted.

Change the number format

Number formatting can be applied to fields within the Values area of the PivotTable.

1. Click the list arrow on the field being used in the Value area of the PivotTable and select Value Field Settings
2. Click the Number Format button
3. Select the format type you wish to use from the Category list and customise the format as necessary



4. Click Ok and then Ok again

The values are formatted with the new number format.

Formatting the table

A PivotTable can be quickly formatted using PivotTable Styles.

1. Select a cell in the PivotTable
2. Click the Design tab under PivotTable Options on the Ribbon
3. Select a style from the PivotTable Styles group

The PivotTable is formatted with the style selected.

You can adjust the formatting for part of the PivotTable by changing the PivotTable Style Options. For example, apply special formatting for the first row of the table, or format odd and even rows differently.

1. Select a cell in the PivotTable
2. Click the Design tab under PivotTable Options on the Ribbon
3. Select from the options in the PivotTable Style Options group

Grouping pivottable data PivotTable options

Guides