| 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 | |||
Linear Mode
