» 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:
- East of Eden (Oprah's Book Club)
- Financial Reporting and Analysis (2nd Edition)
- Advanced modelling in finance using Excel and VBA
- Keys to Reading an Annual Report (Barron's Business Keys)
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
