Share via

Change Pivot Table labels

Anonymous
2015-04-21T15:39:52+00:00

I have a pivot table and I have inserted calculated rows and other columns.  The title I am getting on several of these is "Sum of XXXXX". I want to change the title to simply "XXXXX" but when I try to manually do that I get a message that says PivotTable field name already exists. 

Is there a way to change that without changing the name from the fields I used to create the original pivot table?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Ashish Mathur 101.9K Reputation points Volunteer Moderator
2015-04-21T23:46:58+00:00

Hi,

You may rename the Pivot Table titles as XXXXX  i.e. space after the XXXXX.

Was this answer helpful?

10 people found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful