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.
|