Tip Printed from ExcelTip.com

---

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.