Expand/Collapse Entire Items in a Field in Excel 2007

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:



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