How to Adjust the Pivot Table Field List

How to Adjust the 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.

fieldlistarrange07

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.

Adjust the Field List

Instead of leaving the default settings, the field list can be arranged in different layouts, either stacked or side-by-side

fieldlistarrange04

The list of field names can be sorted alphabetically or in the same order as the source data. If there is a long list of fields, an alphabetical sort can make it easier to find a specific field.

fieldlistarrange05

The position of the field list can also be changed — lock it at the left or right of the worksheet, or let it float on top. Just drag the field list, to put it in a new position.

fieldlistarrange02

Watch the Field List Video

To see the steps for adjusting the field list, you can watch this short video tutorial.

_____________

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.