» 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:
- Microsoft Excel 2002 Simply Visual
- Microsoft Windows XP Registry Guide
- Mortgages For Dummies®
- The New Financial Order: Risk in the Twenty-First Century
- Learn MS Excel 2002 VBA/XML Programming
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
No comments have been submitted.
