How to change the Title of the Grand Total Column on a Pivot Table?

tomlinsn

Board Regular
Joined
Jan 25, 2011
Messages
74
How do you change the description of the "Total" column on a Pivot Table Grand Total Column? I want to edit the name on the Pivot Table Report from Total to Sum of Tuition.

Thank you,
Tonm
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
click on the cell what you want to change then in formula bar type what you want then enter

eg.

screenshot-37.png
 
Last edited:
Upvote 0
Thanks for your quick response, but when I click in the cell that contains the label, I get the following error message:

We can't change this part of the Pivot Table. I can't post my Snip & Sketch image to this reply. How did you do that? Please advise.

Tom
 
Upvote 0
weird, see here:

changetotal.gif


to post any image you need use any service which allow you to get link with extension (jpg, png or gif) then use Insert Image from the ribbon of the post
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,896
Messages
6,175,264
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top