Search Contextures Sites

 

Contextures
Excel news
by email

 

 

 

 

Learn how to create Excel dashboards.

 

Pivot Table Field List

Pivot Table Field List

When you create a pivot table, and select a cell in it, by default, a pivot table field list should appear, at the right of the Excel window. You can use the field list to select fields for the pivot table layout, and to move fields to a specific area in the layout.

pivot table field list

Video: Adjust the Pivot Table Field List

To see the steps for adjusting the pivot table field list, please watch this short video tutorial. The written instructions are below the video.

Change the Pivot Table Field List Layout

By default, the field list shows a list of the fields at the top, and the four pivot table areas in a square at the bottom. You can change that layout, by using a command on the field list.

To change the layout:

  • In the field list, click the arrow for Tools, near the top right
  • The default layout is at the top of the list -- Fields Section and Areas Section Stacked
  • Select one of the other layouts, such as Fields Section and Areas Section Side-by-Side

pivot table field list layout

Which layout to select:

  • The Fields Section and Areas Section Stacked layout is best if the pivot table has long field names, or a short list of fields
  • The Fields Section and Areas Section Side-by-Side layout is better when field names are short, or there is a long list of fields.
  • I don't use the other layouts -- Fields Section Only, Areas Section Only (2 by 2), Area Section Only (1 by 4)

Adjust the Field List Width

To adjust the width of the field list:

  • Point to the border between the field list and the worksheet
  • When the pointer changes to a two-headed arrow, drag left or right, to make the field list wider or narrower

pivot table field list width

Move the Field List

The field list can be locked in place at the right or left of the worksheet, or floating over the worksheet.

To move the field list:

  • Point to the Title area of the field list
  • When the pointer changes to a four-headed arrow, drag the field list to a new position

pivot table field list move

To lock the floating field list into its previous position:

  • Point to the Title area of the field list
  • When the pointer changes to an arrow, double-click, to lock the field list at the side of the worksheet.
  • It will go to the side where it was last locked.

pivot table field list move

Sort the Field List

The fields in the field list can be sorted alphabetically, or in the same order that the fields are arranged in the source data.

To sort the fields in Excel 2013:

  • Click the Tools arrow, at the top right of the Field List
  • In the Sort options, click Sort A to Z or click Sort in Data Source Order

pivot table field list sort 2013

To sort the fields in Excel 2010:

  • Right-click a cell in the Pivot Table, and click PivotTable Options
  • Click the Display tab
  • In the Field List section, click Sort A to Z or click Sort in Data Source Order

pivot table field list sort 2010

 

Pivot Table Tutorials

Pivot Table Introduction 
Clear Old Items in Pivot Table
Create a Pivot Table in Excel 2007 
Custom Calculations 
Data Field Layout
Dynamic Data Source
FAQs - Pivot Tables
Field Settings
Filter Source Data  
Filters, Top 10 
Filters, Report Filters
GetPivotData Function
Grand Totals
Grouping Data
Layout, Excel 2007
Multiple Consolidation Ranges
Pivot Cache   
PivotTable Style
Printing a Pivot Table   
Protection  
Running Totals  
Show and Hide Items 
Sorting
Subtotals 
Summary Functions
Unique Item Count

Pivot Table Books

Beginning Pivot Tables (Excel 2007) 
Pivot Tables Recipe Book (Excel 2003) 
Pivot Tables Recipe Book (Excel 2007) 

Pivot Table Add-Ins

Pivot Power 
Pivot Play PLUS 

Pivot Table Videos

Clear Old Items
Copy a Custom PivotTable Style
Create Pivot Table in Excel 2007
Create Pivot Table from Multiple Sheets
Data Field Layout
Date Filters, Add
GetPivotData
Group Data
Layout, Excel 2007
Report Filters, Add
Running Totals
Select Sections
Subtotals, Create Multiple
Top 10 Filters

 

 

Privacy Policy

 

Contextures Inc., Copyright 2013
All rights reserved.

 

Last updated: July 12, 2013