Expand and Collapse Table Groups

In pivot tables, you can often expand and collapse levels of detail.

To expand or collapse detail in a pivot table, complete the following step:

Do any of the following:

• To expand a table item in a pivot table to reveal detail at the next level, click in that table cell.

• To collapse the detail for a table item, click in that table cell.

• To expand or collapse detail for all items in a column, right-click in that column, and click either Expand All or Collapse All on the shortcut menu.