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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeating Rows - Exception 1
Macro to print pivot 1
Pivot Table Page Break Refresh Problem 0
Repeat Rows at Top - Except Final Page 2
Pivot Table 1
Repeat pivot row or approach to refer to pivot field value... 1
Pivot Table - Repeat row data 1
Pivot Table field names don't match 1

Back
Top