Excel Pivot Table Field List - Activate, move, resize & layout

With the Field List in your Pivot Table, did you know that there are a number of customizations that you can do with it? And I remember the time when my Field List is hidden, I could not find the way on how to make it reappear. I’ll show you how below!

Exercise Workbook:

DOWNLOAD EXCEL WORKBOOK


When you create a Pivot Table in Excel, the field list should automatically appear on the right side of your worksheet. But what if it’s not there? No problem!

STEP 1: Right-click on your Pivot Table and select Show Field List

Excel Pivot Table Field List - Activate, move, resize & layout

Or, you can go to the PivotTable Analyze tab and select Field List.

Excel Pivot Table Field List - Activate, move, resize & layout

 

STEP 2: Click on the down arrow and you get these options: Move, Resize and Close. 

You can either move it to anywhere on your sheet, expand the panel, or make it hidden again.

See also  Use One Slicer for Two Excel Pivot Tables

Excel Pivot Table Field List - Activate, move, resize & layout

STEP 3: Click on the Gear icon and you will be able to change the layout of your Field List.

The default one we are using is the first one: Fields Section and Areas Section Stacked.

Let us have a look at the other layout options!

Excel Pivot Table Field List - Activate, move, resize & layout

Fields Section and Areas Section Side-By-Side:

Excel Pivot Table Field List - Activate, move, resize & layout

Fields Section Only:

Excel Pivot Table Field List - Activate, move, resize & layout

Areas Section Only (2 by 2):

Excel Pivot Table Field List - Activate, move, resize & layout

Areas Section Only (1 by 4):

Excel Pivot Table Field List - Activate, move, resize & layout

And there you have it with the different layout options!

 

field li

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