» 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:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Windows XP Registry Guide
- Finance and Accounting for Nonfinancial Managers
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Accounting the Easy Way
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
