Excel > Excel 2007 Advanced > PivotTable and PivotCharts

PivotTable Options

PivotTable options allow you to control the behaviour of a PivotTable. Options include preserving the formatting on refresh, the positioning of subtotals and enabling show details.

Show/Hide PivotTable elements

The Show/Hide group on the Options tab allow you to show or hide the Field List, expand and collapse buttons and field headers.

  1. Select a cell in the PivotTable
  2. Click the Options tab under PivotTable Tools on the Ribbon
  3. The Show/Hide group contains three buttons.

    Show/Hide group

  • Field List: Click to show or hide the PivotTable Field List
  • +/- Buttons: Click to show and hide the buttons that enable you to expand and collapse PivotTable items
  • Field Headers: Click to show or hide row and column field headers
  1. Click the button from the group that you want to use

PivotTable layout options

  1. Select a cell in the PivotTable
  2. Click the Design tab under PivotTable Tools on the Ribbon
  3. The Layout group contains four buttons.

    Layout group

  • Subtotals: Click to show or hide subtotals and specify where to position them
  • Grand Totals: Click to show or hide grand totals and specify whether to show them for rows, columns or both
  • Report Layout: Show the PivotTable in compact, outline or tabular form
  • Blank Rows: Insert or remove a blank line between each grouped item in the PivotTable
  1. Click a button in the Layout group and select an option from the menu

Changing PivotTable Options

To change PivotTable options:

  1. Click in the PivotTable
  2. Click the Options button in the PivotTable group of the Options tab under PivotTable Tools
  3. The PivotTable Options dialogue box is displayed.

    PivotTable options

  4. Change the desired options
  5. Click Ok

Follow us on

Facebook  Twitter  You Tube