View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tommcbrny tommcbrny is offline
external usenet poster
 
Posts: 57
Default Repeat Pivot Row on when printing

Hi, I have an Excel 2007 pivot table laid out in Compact Form. The first
field in Row Labels, a name, contains several pages of data beneath. Is
there a way for me to print this name on each page of the printout until the
next name appears?

I have selected to page break after each item in this field, this works
well. I now want to have the field value repeated at the top of each page
unitl the next name appears if possible.

Thank you,
Tom