Specifying Cell and Header Styles

Specifying Cell and Header Styles

To specify the cell and header styles for an item:

1. Click the Advanced Options button next to the item or in the header of the Rows or Columns box, as appropriate.

   See Customizing Pivot Table Items.

2. Select values in the Cell Style and Header Style groups. These enable you to specify the style of the cells and the headers, respectively:

   

   To use these options, click each drop-down and select a value. For example:

   

   This style definition specifies that the header is in 12 pt, blue Verdana on a pale green background. The header is also bold and center-aligned.

3. Click OK.