Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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/
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column headers appearing on every page Craig G Setting up and Configuration of Excel 2 June 11th 07 11:32 AM
change and/or remove page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:15 AM
PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE RALPH Setting up and Configuration of Excel 3 March 16th 06 11:08 PM
any way to redisplay column headings after page break? Gerald Morris Excel Worksheet Functions 2 June 29th 05 06:39 PM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"