Open the pivot table settings pane

You can configure the pivot table by using the pane that contains the following tabs:

•Constructor: Use this tab to select the structure (layout) of the pivot table.

•Options: This tab contains the pivot table parameters.

The pivot table settings pane opens automatically when you select any cell in the pivot table and collapses automatically when you select any cell outside the pivot table.

You can also open and collapse the pivot table settings pane manually.

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

•At the top of the pane, click .

•On the Sidebar, click  Pivot Table.

To open the pane manually, do the following:

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

2.Open the pane in one of the following ways:

•In the Data menu, click Pivot Table Settings.

•On the Toolbar, in the Pivot Table section, click  Pivot Table Settings.

•On the Sidebar, click  Pivot Table.

•Right-click to open the context menu and run the Pivot Table Settings command.