View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
mjc mjc is offline
external usenet poster
 
Posts: 3
Default 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.