|
| 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
December 9th, 2005, 09:58 PM
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
December 10th, 2005, 11:59 AM
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
|
| 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 |
Linear Mode
