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:

---

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

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

 

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.

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!

Fields Section and Areas Section Side-By-Side:

Fields Section Only:

Areas Section Only (2 by 2):

Areas Section Only (1 by 4):

And there you have it with the different layout options!

 

field li