Open the pivot table settings pane
- Create a pivot table
- Open the pivot table settings pane
- Customize a pivot table
- Customize the pivot table parameters
- Collapse or expand the elements of pivot table
- View cell details
- Refresh a pivot table
- Delete a pivot table
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.
