|  

» Printing a PivotTable Report

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.
Screenshot // Printing a PivotTable Report
Printing a PivotTable Report


Rate This Tip
12 34 5
Rating: 3.50     Views: 13545
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments