Expand and Collapse Table Groups

In pivot tables, you can expand and collapse groups of data to control the level of detail that displays

To expand and collapse table groups, complete the following step:

Do one or more 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.