Format a PivotTable list and its elements

Office PivotTable Lists

Show All Show All

Format a PivotTable list and its elements

  1. Select the element that you want to format.

    ShowHow?

  2. Click Commands and Options Button image on the PivotTable list toolbar.
  3. Do one of the following:
    • To format a drop area, click the Captions tab.
    • To format an item property of a row or column field, click the Item Properties tab.
    • To format all other elements of a PivotTable list, click the Format tab.
  4. Do one or more of the following:

    ShowSpecify font and style settings

    ShowAlign text

    ShowSet background color

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

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.