O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Renaming Fields and Items

You don't have to use the field and item names supplied by the PivotTable And PivotChart Wizard. You can change these names by editing the field heading or any occurrence of the item in the PivotTable. When you change the name of an item in this manner, all other occurrences of the item are changed as well. For example, you can change the CatalogNo heading to Title in Figure 30-15 by selecting the heading in cell A6, typing Title, and then pressing Enter.

Caution

Don't change a field heading in your PivotTable to the name of another field in your data source. Doing so will have unintended consequences.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required