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

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.