» 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:
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Marketing Plans
- Financial Reporting and Analysis (2nd Edition)
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Microsoft Access 2002 for Dummies
No comments have been submitted.
