Pinterest Pixel

Show Field and Value Settings in Excel Pivot Tables

With Excel Pivot Tables you can do a lot of stuff with your data! But did you... read more

Download Excel Workbook
Bryan
Posted on

Overview

Show Field and Value Settings in Excel Pivot Tables | MyExcelOnline Show Field and Value Settings in Excel Pivot Tables | MyExcelOnline

With Excel Pivot Tables you can do a lot of stuff with your data! But did you know that you can edit your Field and Value Settings in Pivot Table in multiple places?

Let me show you the different shortcuts so that you can tinker with your Pivot Table!

Show Field and Value Settings in Excel Pivot Tables | MyExcelOnline

Download excel workbookField-Value-Field-Settings.xlsx

 

STEP 1: Let us have a look at the existing Pivot Table. To view the Field Settings, we can do the following:

Under PivotTable Fields > Rows > Field Settings

Show Field and Value Settings in Excel Pivot Tables

You can also right click on a Row Label and select Field Settings.

Show Field and Value Settings in Excel Pivot Tables

Or while having a row label selected, you can go to PivotTable Tools > Analyze > Active Field > Field Settings

Show Field and Value Settings in Excel Pivot Tables

And now you have your Field Settings open!

Show Field and Value Settings in Excel Pivot Tables

 

STEP 2: Now let us see how to access the Value Field Settings.

Go to PivotTable Fields > Values> Value Field Settings

Show Field and Value Settings in Excel Pivot Tables

You can also right click on a Value and select Value Field Settings.

Show Field and Value Settings in Excel Pivot Tables

Or while having a value selected, you can go to PivotTable Tools > Analyze > Active Field > Field Settings

Show Field and Value Settings in Excel Pivot Tables

 

You now have your Value Field Settings!

Show Field and Value Settings in Excel Pivot Tables

 

How to Show Field and Value Field Settings In Pivot Tables

 

If you like this Excel tip, please share it
Show Field and Value Settings in Excel Pivot Tables | MyExcelOnline Show Field and Value Settings in Excel Pivot Tables | MyExcelOnline
Show Field and Value Settings in Excel Pivot Tables | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Pivot Table Styles

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!

Share to...