» Printing a PivotTable Report
CATEGORY - Excel Printing
VERSION - All Microsoft Excel Versions
1. Select one of the cells in the PivotTable report.
2. Press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the PivotTable report.
3. From the File menu, select Set Print Area (when using Excel 97 and Excel 2000, pressing Ctrl+Shift+* selects the entire PivotTable report, including the fields in the page field).
4. To only print the itemization rows in the detailed lower section of the PivotTable report, select the rows without using the Ctrl+Shift+* shortcut and set the Print Area.
Book Store:
Recommended Books:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- How to Read A Financial Report
- Microsoft Windows XP Registry Guide
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Special Edition Using Microsoft Access 2002
- Writing Excel Macros with VBA, 2nd Edition
No comments have been submitted.
