Tip Printed from ExcelTip.com

---

Expand/Collapse Entire Items in a Field in Excel 2007


To expand/collapse entire items in a field:

1. Select an item in the Row Labels field area (2003 (item) in Years field, see screenshot below).
2. Select PivotTable Tools -> Options -> Collapse Entire Field (in Active Field Group).

Before Collapse:



After Collapse:



To expand/collapse an Item:

Double-click an item in the Row Labels field area (2003 (item) in Years field, see screenshot above).