Change Pivot Table Data Headings and Blanks

When you add fields to the value area in a pivot table, custom names are automatically created, such as Sum of Quantity or Count of Customer.

pivotlabels01

Excel won’t let you remove the “Sum of” in the label, and just leave the field name. However, you can change the heading to the field name, plus a space character, to work around this problem.

In the screen shot below, the heading has been changed to [space]Qty.

pivotlabels02

Change (Blank) Labels

Another formatting fix that you can make is to get rid of the labels that say “(Blank”)”. These appear if cells are blank in the source data, and you add those fields to the row or column labels area.

pivotlabels03

Excel shows an error message if you just try to delete those labels, but you can use a space character to replace them.

Watch the Video

Watch this short video tutorial to see how to make these changes to the pivot table headings and labels.

________________________

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.