See workarounds for showing a grand total at the top or at the left, and other grand total tricks. In the pivot table shown below, I was able to change the Row “Grand Total” heading, without any problems.įor more information, go to the pivot table Grand Totals page on my Contextures website. You can’t change the “Total Field” headings, but you CAN still edit the “Grand Total” heading in that pivot table. However, that error message is a bit misleading. If you try to edit a Total Field heading, an error message will appear: “Cannot edit subtotal, block total, or grand total names.” It was easy to change the original “Grand Total” headings, but Excel won’t let you change these “Total Field” headings But some users may not need the grand total row/column at all.
The Row Grand Total, in cell A11, did not change. How to hide grand total in an Excel pivot table Generally speaking, the Grand Total row will be added at the bottom of a pivot table automatically in Excel, and the Grand Total column will be added automatically if you specify the column labels as below screenshot shown. Now, instead of a Grand Total column at the right, there are columns with “Total” and the field names – Total Qty and Total Orders In the screen shot below, the Order Count field was added to the Values area. If there are multiple Value fields in a pivot table, Excel shows a different set of grand total headings. In the screen shot below, I typed “GT” in cell D4, to create a smaller heading in column D.Īs soon you complete the name change, Excel automatically changes the other Grand Total heading, to the same text. NOTE: You can’t double-click the cell to edit the text.