Repeat Pivot Row on when printing

  • Thread starter Thread starter tommcbrny
  • Start date Start date
T

tommcbrny

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
 
The Repeat Row Labels on Each Printed Page setting only has an effect if
the pivot table is in Tabular Form or Outline Form.
 
Back
Top