Pivot table - repeat header on new page
 

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.

Pivot table - repeat header on new page
 

Go to Page Setup, select the Sheet tab, and, under the option Rows to repeat
at top, select the appropriate rows.
--
Brevity is the soul of wit.


"mjc" wrote:

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.

Pivot table - repeat header on new page
 

Bingo. I'm an idiot. Thanks!

"Dave F" wrote:

Go to Page Setup, select the Sheet tab, and, under the option Rows to repeat
at top, select the appropriate rows.
--
Brevity is the soul of wit.


"mjc" wrote:

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.

Pivot table - repeat header on new page
 

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.

mjc wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html