Pinterest Pixel

Field Name Formatting in Excel Pivot Tables

When we work with Pivot Table Fields, the names get generated automatically. Either they come from the... read more

Download Excel Workbook
Bryan
Posted on

Overview

Field Name Formatting in Excel Pivot Tables

When we work with Pivot Table Fields, the names get generated automatically. Either they come from the main data source, or Excel generates this for us. But what if you have a better name in mind?

I will show you how to set up field name formatting in Excel Pivot Tables!

 

Exercise Workbook:

Download excel workbookField-name-formatting.xlsx


Here is our Pivot Table. We want to change the Sum of SALES to Total Sales for better readability.

Field Name Formatting in Excel Pivot Tables

STEP 1: Click on the arrow beside Sum of SALES and select Value Field Settings

Field Name Formatting in Excel Pivot Tables

STEP 2: Type Total Sales for the Custom Name and click OK

Field Name Formatting in Excel Pivot Tables

Now you have Total Sales as your Field Name!

Field Name Formatting in Excel Pivot Tables

STEP 3: There is another way to do this. Now we want to change SALES YEAR to Financial Year

Select any SALES YEAR label in your Pivot Table. Go to PivotTable Analyze > Active Field > Active Field

Type in Financial Year as the new name:

See also  Free Pivot Table Webinar

Field Name Formatting in Excel Pivot Tables

And you can see your new field name take effect!

Field Name Formatting in Excel Pivot Tables

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Field Name Formatting in Excel Pivot Tables | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!