Field and Value Settings in Excel Pivot Tables

Are you aware of this feature of the pivot table that you can edit your field and value settings in multiple places of your pivot table? Alright if you don’t know about this then here I will share different shortcuts so that you can do it in your Pivot Table.

Previously In Pivot TablesHow To use Recommended Pivot Tables in Excel

FIELD SETTINGS IN EXCEL PIVOT TABLES

OPTION1. Under PivotTable Fields > Rows > Field Settings

Where to Find Field and Value Settings in Excel Pivot Tables? 1

OPTION2. Also, you can do the right click onRow Label and select there your Field Settings.

Where to Find Field and Value Settings in Excel Pivot Tables? 2

OPTION3. Go to PivotTable Analyze > Active Field > Field Settings

Where to Find Field and Value Settings in Excel Pivot Tables? 3

You have got your open Field Settings.

VALUE SETTINGS IN EXCEL PIVOT TABLES

OPTION1. Go to PivotTable Fields > Values> Value Field Settings

Where to Find Field and Value Settings in Excel Pivot Tables? 4

OPTION2. You can also do a right-click on a Value and select your Value Field Settings there.

Where to Find Field and Value Settings in Excel Pivot Tables? 5

 There you go with your Value Field Settings!