![]() |
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 |
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 |
All times are GMT +1. The time now is 03:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com