Show or hide detail data for an item or field
- Do one of the following:
-
To show or hide detail data for a cell, or an item at the lowest level, select the item or cell.
- To show or hide detail data for a row or column field, select the row or column field.
-
- Click Show Details
or Hide Details 
on the PivotTable list toolbar.
Note To show or hide lower-level items, select the row or column field or item, and then click Expand 
or Collapse 
on the toolbar.