Field Name Formatting in Excel Pivot Tables | MyExcelOnline

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 WORKBOOK


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 | MyExcelOnline

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

Field Name Formatting in Excel Pivot Tables | MyExcelOnline

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

Field Name Formatting in Excel Pivot Tables | MyExcelOnline

Now you have Total Sales as your Field Name!

Field Name Formatting in Excel Pivot Tables | MyExcelOnline

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:

Field Name Formatting

And you can see your new field name take effect!

Field Name Formatting in Excel Pivot Tables | MyExcelOnline

 

HELPFUL RESOURCE:

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

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Linkedin