» Show/Hide Expand Items Buttons 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. To hide the expand button (on the left of 2003 item or Qtr1item), select PivotTable Tools -> Options -> Buttons (in Show/Hide Group).
Show mode:
Hide mode:
Book Store:
Recommended Books:
- Positioning: The Battle for Your Mind
- Excel 2002 Power Programming with VBA
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Writing Excel Macros with VBA, 2nd Edition
- Special Edition Using Microsoft Word 2002
No comments have been submitted.
