Printing Pivot Table Headings on each page – Office 2010
Your Pivot Table spans several printed pages and the page, row and column headings only print on the first page – Follow the instructions below if you want the headings on every page
|
Click on the tab that contains your pivot table first.
On the Excel Worksheet menu, choose the Page Layout tab.
|
|
|
Click on the Print Titles icon
|
|
|
Change the rows to repeat at the top:
For example:
Change rows to repeat at top from row 4 through 18 to Rows 18:18
Click OK to close the Page Setup dialog box.
|
|
|
Right-click a cell in the pivot table, and choose PivotTable Options.
Click on the Printing tab.
Add a checkmark to Set print titles.
Click OK to close the Pivot Table options dialog box.
|
|