You can also click Field List on the Ribbon ( PivotTable Tools, Options tab, Show group for a PivotTable PivotChart Tools, Analyze tab, Show/Hide group for a PivotChart).
Right-click the PivotTable, and then click Show Field List. If you close the PivotTable Field List, you can display it again. If you don't see the PivotTable Field List, make sure that you click anywhere in the PivotTable. You can also undock the PivotTable Field List, in which case, you can resize it both vertically and horizontally. You can dock the PivotTable Field List to either side of the Excel window and horizontally resize it. By default, the PivotTable Field List displays two sections:Ī field section at the top for adding fields to and removing fields from the PivotTableĪ layout section at the bottom for rearranging and repositioning fields
When you create a PivotTable, Excel displays the PivotTable Field List so that you can add fields to the PivotTable, rearrange and reposition them as needed, or remove them from the PivotTable.
