If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Keeping Column Widths the same in a pivot table when pages increase | [email protected] | General Discussion | 1 | June 3rd, 2005 01:38 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Pivot Table Zero Value | jcliquidtension | General Discussion | 0 | January 13th, 2005 04:21 AM |
Using Validation to force entry into cells? | Mark | General Discussion | 16 | October 27th, 2004 09:23 PM |
adding column to preexisting pivot table | btcdeb | General Discussion | 5 | August 9th, 2004 12:56 AM |