Page Break Column Headers

[Guest]

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]

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.