Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column headers appearing on every page | Setting up and Configuration of Excel | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel | |||
any way to redisplay column headings after page break? | Excel Worksheet Functions | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |