Format a PivotTable list and its elements

  1. Select the element that you want to format.

    How?

    Select the entire PivotTable list

    Note   You can't display the title bar if the PivotTable list is not bound to a data source.

    Select one or more data cells

    Select a row, column, or filter field

    Note   Selecting a row or column field also selects all of the items of data in the field.

    Select a detail field

    Select a total field

    Select one or more items

    Note   Selecting an item selects all of the data for that item.

    Select a subtotal or grand total

    Note   Selecting a subtotal or grand total also selects all of the data for the subtotal or grand total.

    Select the title bar or a drop area

    1. Click the title bar.

    2. On the PivotTable list toolbar, click Commands and Options , and then click the Captions tab.

    3. In the Select caption list, select the item you want.

    Select a custom property of a row or column field

    1. Click the row or column field, or one of its items.

    2. On the PivotTable list toolbar, click Commands and Options , and then click the Item Properties tab.

    3. In the Item properties list, select the property you want.

      Note   If the selected field does not have any custom properties, the Item properties list will be empty.

      You can set the caption, number format, and display location settings for the selected property. The formats you select affect only the selected property.

    4. To set the font and style settings of a property, select Property caption or Property value from the Format list.

    Note   Font and text style settings that you apply to a custom property affect all custom properties in the PivotTable list, but only when they are displayed in the report. The formatting is ignored when the custom property is displayed in the ScreenTip.

  2. Click Commands and Options on the PivotTable list toolbar.
  3. Do one of the following:
  4. Do one or more of the following:

    Specify font and style settings

    Notes

    Align text

    Note   You cannot set the text alignment for an entire PivotTable list in one operation. You cannot change the horizontal alignment of row, column, or filter field labels.

    Set background color

    Note   You cannot set the background color for an entire PivotTable list in one operation. You cannot change the background color of the drop areas.

    Change the number format of a field, total, or item property of a row or column field

    Note   The number format of a field does not affect the number format of other row, column, filter, or total fields. The number format of an item property does not affect other item properties.

Note   You can't format the contents of a ScreenTip. Therefore, the formats you apply to an item property apply to the property only when it is displayed in the report.