» Printing a PivotTable Report
CATEGORY - Excel Printing
VERSION - All Microsoft Excel Versions
To print a PivotTable report: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:
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- How to Read A Financial Report
- Positioning: The Battle for Your Mind
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
No comments have been submitted.
