Pivot table settings pane

The pivot table settings pane contains the following tabs:

•Constructor: Defines the structure of the pivot table.

•Parameters: Contains the parameters of the pivot table.

The pivot table settings pane opens automatically when any cell in the pivot table is selected and closes automatically when any cell outside the pivot table is selected. You can also open and close the settings pane manually.

To close the pane manually, do one of the following:

•At the top of the pane, click the button.

•On the Sidebar, click the  Pivot table button.

To open the pane manually, follow these steps:

1.Select the entire range or one or more cells from the range of the pivot table.

2.Open the pane using one of the following methods:

•In the Command menu, select Data > Pivot table settings.

•On the Toolbar, click the  Pivot table settings button.

•On the Sidebar, click  Pivot table button.

•Right-click to open the context menu and execute the Pivot table settings command.