Pivot table - repeat header on new page

M

mjc

I'm trying to run a report generated from a pivot table. Each entry is
separated by a new page break, but the header row doesn't repeat. Is there a
way to do this? Thanks.
 
D

Dave F

Go to Page Setup, select the Sheet tab, and, under the option Rows to repeat
at top, select the appropriate rows.
 
M

mjc

Bingo. I'm an idiot. Thanks!

Dave F said:
Go to Page Setup, select the Sheet tab, and, under the option Rows to repeat
at top, select the appropriate rows.
Click to expand...
 
D

Debra Dalgleish

You can right-click on the pivot table, and choose Table Options
Add a check mark to Set Print Titles, click OK.
There's also an option to Repeat items labels, that you may want to enable.
 
Top