| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat Pivot Row on when printing
The Repeat Row Labels on Each Printed Page setting only has an effect if
the pivot table is in Tabular Form or Outline Form. tommcbrny wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row to repeat while printing | Excel Discussion (Misc queries) | |||
| Repeat rows on top - in worksheet - not printing! | Excel Worksheet Functions | |||
| Repeat rows on bottom when printing in Excel | Excel Discussion (Misc queries) | |||
| Repeat form printing with new data by macro | Excel Discussion (Misc queries) | |||
| How do I repeat a row of headings when printing an excel spreadshe | Excel Discussion (Misc queries) | |||
Linear Mode
