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!

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

DOWNLOAD EXCEL WORKBOOK

 

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 Field Settings in Power Query

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

Show Field and Value Field Settings in Power Query

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

Show Field and Value Field Settings in Power Query

And now you have your Field Settings open!

Show Field and Value Field Settings in Power Query

 

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 Field Settings in Power Query

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

Show Field and Value Field Settings in Power Query

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

Show Field and Value Field Settings in Power Query

 

You now have your Value Field Settings!

Show Field and Value Field Settings in Power Query

 

How to Show Field and Value Field Settings In Pivot Tables

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

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