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

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

field list hidden

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

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

 

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.

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

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 | MyExcelOnline

Fields Section and Areas Section Side-By-Side:

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

Fields Section Only:

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

Areas Section Only (2 by 2):

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

Areas Section Only (1 by 4):

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

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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn