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!

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 101 Best Excel Tips & Tricks:

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

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!field li

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