» 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:
- Learn MS Excel 2002 VBA/XML Programming
- Microsoft Excel Version 2002 Step by Step
- Writing Excel Macros with VBA, 2nd Edition
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Getting to Yes: Negotiating Agreement Without Giving In
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
