Print a PivotTable

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

1. Click the PivotTable.

2. On the Analyze tab, in the Actions group, click Select, and then click Entire PivotTable.

3. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.
   
   

Page Layout view is useful for getting your data ready for printing. For example, you can use the rulers to measure the width and height of the data, change the page orientation, add or change page headers and footers, set margins for printing, and hide or display row and column headers.

1. On the View tab, in the Workbook Views group, click Page Layout.

   Tip: You can also click Page Layout View on the status bar.

2. Make adjustments to the page layout.

You can repeat the row labels and column labels of a report on every printed page as print titles. When you change the layout of the report so that the labels are shown in different worksheet rows and columns, the new label rows and columns are repeated automatically the next time you print the report.

1. On the Page Layout tab, in the Page Setup group, click Print Titles.
   
   

2. In the Page Setup dialog box, make sure that the Rows to repeat at top and Columns to repeat at left check boxes are cleared.

3. Close the Page Setup dialog box.

4. On the Analyze tab, in the PivotTable group, click Options.

5. In the PivotTable Options dialog box, click the Printing tab, and then select the Set print titles check box.

6. If your report has more than one row label and you also want to repeat the outer row label items on each page, select the Repeat row labels on each printed page check box.

When your report has multiple row labels and a page break falls within a group of row label items, you can set the report to automatically repeat the item labels for the outer labels at the top of the next page. In a report with two or more row labels, all but the rightmost label are outer row labels. In the following example, the report is set so that the items East and Qtr2 from the outer row labels Region and Qtr are printed on the next page after the page break.

1. Page break within an item group.

2. Item labels from the outer row labels are repeated on page 2.

1. Right-click the outer row label that has the items that you want to print on separate pages, and then click Field Settings on the shortcut menu.

2. In the Field Settings dialog box, click the Layout & Print tab.

3. Select the Insert page break after each item check box.

It is a good idea to review the entire PivotTable in Page Break Preview, in case you need to make additional adjustments of the page breaks.

• On the View tab, in the Workbook Views group, click Page Break Preview.

  You can insert new manual page breaks and move and delete automatic page breaks. For more information, see Add, delete, or move page breaks.

You may or may not want to print the expand and collapse buttons. To decide whether you want to print the expand and collapse buttons, do the following:

• To show or hide the expand and collapse buttons on the worksheet, on the Analyze tab, in the Show/Hide group, click +/- Buttons.

• To show or hide the expand and collapse buttons on the printed report, do the following:

  1. On the Analyze tab, in the PivotTable group, click Options.

  2. Click the Printing tab, and then select or clear the Print expand/collapse buttons when displayed on PivotTable check box.

     Note: This check box requires the +/- Buttons command in the Show/Hide group on the Options tab to be turned on.

1. To check your final print layout, click File > Print, and see the preview.

   Keyboard shortcut  You can also press CTRL+F2.

   Make final adjustments as necessary. For more information, see Preview worksheet pages before printing.

2. When the preview looks correct, click Print.