Rename a PivotTable field or item

Microsoft Office Excel 2003

Show All Show All

Rename a PivotTable field or item

  1. Click the field or item you want to rename.
  2. Type a new name.
  3. Press ENTER.

Notes

  • If you hide and then redisplay levels in PivotTable reports based on OLAP source data, any renamed fields or items revert to their original names.
  • Renaming a numeric item changes it to text, which sorts separately from numeric values and can't be grouped with numeric items.