Repeat Pivot Table Headings When Printing

If your pivot table spans two or more printed pages, the page, row and column headings might only print on the first page. You can set an option for the pivot table to make the page, row, and column headings appear on every sheet when you print the pivot table. This will make it easier for readers to understand the report, without flipping back to the first page to see the headings.

Before you turn on this option, clear any entries for row and column titles on the worksheet. If either of these boxes contains an entry, the Set print titles option won’t be applied.

  1. On the Excel Worksheet menu, choose File | Page Setup.
  2. On the Sheet tab, under Print titles, clear the Rows to repeat at top and Columns to repeat at left boxes.
  3. Click OK to close the Page Setup dialog box.

Next, you’ll turn on the Print Titles option. Note that only one pivot table per worksheet can have the Set print titles option selected.    

  1. Right-click a cell in the pivot table, and choose Table Options.
  2. Add a checkmark to Set print titles.
  3. Click OK to close the PivotTable Options dialog box.



    For more information on pivot tables, see the Pivot Table Topics on my Contextures web site.


This entry was posted in Print and Extract. Bookmark the permalink.

Leave a Reply

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