Show All

Print a PivotTable report

1. If you have more than one PivotTable report on the worksheet, set a print area that includes only the report you want to print.

   How?

   1. Click the report.
   2. On the PivotTable toolbar, click PivotTable, point to Select, and then click Entire Table.
   3. On the File menu, point to Print Area, and then click Set Print Area.
2. On the File menu, click Page Setup, and adjust the page settings, sheet settings, margins, and headers and footers.
3. If you want to repeat the row and column labels from the report on each page as print titles, clear the Rows to repeat at top and Columns to repeat at left boxes, and then set PivotTable print titles.

   How?

   1. On the PivotTable toolbar, click PivotTable, and then click Table Options.
   2. Under Format options, select the Set print titles check box.
   3. If your report has more than one row field and you also want to repeat outer row field items on each page, select the Repeat item labels on each printed page check box.
4. If your report has more than one row field and you want automatic page breaks after each item in one or more outer row fields, set these page breaks.

   How?

   1. Double-click the outer row field that has the items you want to print on separate pages.
   2. Click Layout.
   3. Select the Insert page break after each item check box.
5. On the View menu, click Page Break Preview, and make any adjustments you want to the page breaks.

   You can insert new manual page breaks and move and delete automatic page breaks.

6. On the File menu, click Print Preview, and check your print layout. To make adjustments, you can repeat any of the previous steps as needed.
7. When the preview looks correct, click Print.