ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Page Break Column Headers (https://www.excelbanter.com/excel-worksheet-functions/149075-page-break-column-headers.html)

John Walker

Page Break Column Headers
 
Hi,
I'm using Excel 2003.
I know how to repeat column headers on every page (by setting the "rows to
repeat at top" field) but what i'm looking to do is to repeat column headers
only on every manual page break. Is there a way to do that?
Thanks!
John

Stan Brown

Page Break Column Headers
 
Thu, 5 Jul 2007 07:06:00 -0700 from John Walker
:
I'm using Excel 2003. I know how to repeat column headers on every
page (by setting the "rows to repeat at top" field) but what i'm
looking to do is to repeat column headers only on every manual page
break. Is there a way to do that?


To the best of my knowledge, there's no way to tie them
*automatically* to manual page breaks.

I can only suggest that you duplicate those rows at the points of the
manual page breaks, and then clear the "rows to repeat" setting.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com