Change title, captions, and labels

Office PivotTable Lists

Show All Show All

Change title, captions, and labels

You can change the title of the PivotTable list, the field names, the names of items within fields, and names of total fields. The changes you make don't affect the source data.

  1. Click Commands and Options Button image on the PivotTable list toolbar.
  2. Do one or more of the following:

    ShowChange the title bar text or the caption of a drop area

    ShowChange the caption of a field, fieldset, or custom group field

    ShowChange the caption of an item property

    ShowChange the caption of an item or custom group

Note  If you don't want a caption for the selected item, clear the Caption text box.