Pinterest Pixel

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

Bryan
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 workbookField-List-Activate-move-resize-layout.xlsx


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.

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

If you like this Excel tip, please share it



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


Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Top 3 Excel Pivot Table Issues Resolved

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...