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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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,216,759
Messages
6,132,556
Members
449,735
Latest member
Gary_M

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