Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I keep column titles on subsequent pages of a pivot table
When you have a pivot table that is two or more pages long, how do you go
about ensuring that the column titles are on each page? looking forward to your thoughts cheers |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I keep column titles on subsequent pages of a pivot table
Hi
From the drop down on the PT toolbar, select Options and select Set Print Titles. Regards Roger Govier Zoo7 wrote: When you have a pivot table that is two or more pages long, how do you go about ensuring that the column titles are on each page? looking forward to your thoughts cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Sort a Column of Dates in Pivot Table | Excel Worksheet Functions | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions |