Changing labels in a PivotTable:

In this tip, I will explain how to change the labels in a Pivot table.

The standard labels, “Column Labels” and “Row Labels” (A), which are used in a PivotTable make no sense, especially when you are printing this PivotTable.

In order to modify the title field, select the “Design” tab, click the “Report Format” button in the “Ribbon” and select “Table Display” from the pop-up menu.

This displays both labels (1) again, as they are listed with the title for the field. Now, this is a lot clearer.
However, the label that does not change, is the “Total sum of” (A) label.

We change this value in a cell by right clicking in the PivotTable and selecting “Value Field Settings” in the popup menu.
In the window that appears, type the name for the label.
Attention!
When you select a name that already appears as a field, such as “Total”, then Excel will give you a warning that the field name already exists so you need to type something else.

However, if you wish to keep the same name as that of an existing field name, there is a trick to do it.
Type a space after the name, then click the OK button.

This way you can deceive Excel and you will still have the desired label name.

TIP:
A much faster way you can change is, double-click the cell with the label and type the name you wish to use.
Also do not forget a space when you want to use a name already being used as field name.

FYI: Swotster.com thinks of its students, so you also remember swotster.com

Copyright © 2013 – Swotster Ltd.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats