Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - repeat header on new page
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - repeat header on new page
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - repeat header on new page
You can right-click on the pivot table, and choose Table Options
Add a check mark to Set Print Titles, click OK. There's also an option to Repeat items labels, that you may want to enable. 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set Header Row to repeat on each page | Excel Discussion (Misc queries) | |||
Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
Pivot Table page fields | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Automatically print all page contents in pivot table. | Excel Worksheet Functions |