Excel > Excel 2003 Advanced > PivotTables and PivotCharts

PivotTable Options

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

To change PivotTable options:

  1. Click in the PivotTable
  2. Click the PivotTable button on the PivotTable toolbar and select Table Options
  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