» Expand/Collapse Entire Items in a Field in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft 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:

To expand/collapse an Item:
Double-click an item in the Row Labels field area (2003 (item) in Years field, see screenshot above).
Book Store:
Recommended Books:
- Windows XP Annoyances
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Windows XP Pocket Reference
- Microsoft Excel Version 2002 Step by Step
- The New Financial Order: Risk in the Twenty-First Century
No comments have been submitted.

