Expand, Collapse, Or Show Details In A PivotTable Or PivotChart

You can show or hide details and disable or enable the corresponding option.

Show value field details

• In a PivotTable, do one of the following:

  • Right-click a field in the values area of the PivotTable, and then click Show Details.

  • Double-click a field in the values area of the PivotTable.

    The detail data that the value field is based on is placed on a new worksheet.

Hide value field details

• Right-click the sheet tab of the worksheet that contains the value field data, and then click Hide or Delete.

Disable or enable the option to show value field details

1. Click anywhere in the PivotTable.

2. On the Options or Analyze tab (depending on the Excel version you are using) on the ribbon, in the PivotTable group, click Options.

   

3. In the PivotTable Options dialog box, click the Data tab.

4. Under PivotTable Data, clear or select the Enable show details check box to disable or enable this option.

   Note: This setting is not available for an OLAP data source.