View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default 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/