Expand and Collapse Groups in Pivot Tables

To expand/collapse groups of values, do one of the following:

Click a corresponding expand button:

Right-click a value that has nested values, and select the required Expand or Collapse command from the menu that opens:

Previous Lesson: Advance Filter Data in Pivot Tables Table of Contents Next Lesson: Expand and Collapse Fields in Pivot Tables