Show or hide items
- To show or hide the lower-level items of a specific item in the row or column axis, click the expand indicator (
or
box) next to the item.
- To show or hide the lower-level items for all items in a row or column field, click the field label, and then click Expand
or Collapse
on the PivotTable list toolbar.
Notes
-
If the
or
box is not visible next to the item, select the Expand indicator check box on the Behavior tab of the Commands and Options dialog box. If after selecting the check box you don't see an expand indicator next to an item, the item might be at the lowest level available for the source data.
- To show or hide details, select the item or field, and then click Show details
or Hide details
on the toolbar.