Show 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 Microsoft Excel window. You can use the field list to select fields for the pivot table layout, and to move pivot table fields to a specific area in the layout.

Show PivotTable Field List

To see the PivotTable Field List:

• Click any cell in the pivot table layout.
• The PivotTable Field List pane should appear at the right of the Excel window, when a pivot cell is selected.

If the PivotTable Field List task pane does not appear automatically, follow these steps to enable it:

• Click any cell in the pivot table layout.
• On the Excel Ribbon, click the PivotTable Analyze tab
• Then in the Show group (at the far right), click the Field List command.

Note: If the full Show group is not visible, click Show, Field List (from the drop down list of commands)

.

Close PivotTable Field List

Sometimes, you might want to hide the PivotTable Field List, to discourage people from making changes to the pivot table layout.

Or, on so

how to see pivot table in excel

how to check pivot table in excel