Repeating rows not wanted

[Opal]

I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?

 

[Gord Dibben]

You cannot do this.

Rows to repeat at top must start from the top and be contiguous.


Gord Dibben MS Excel MVP

 

[Glenn]

It seems to work for me, but maybe not in the way the OP wants it. If I number
the cells in column A with the row number, then go to File / Page Setup / Sheet
/ Rows to repeat at top: and enter $12:$13, my printed pages show the following:

Page 1 - number 1 through 52
Page 2 - number 12 & 13 and then 53 through 102
Page 3 - number 12 & 13 and then 103 through 152
Page 4 - number 12 & 13 and then 153 through 202

 

[Bernard Liengme]

I see the same type of behaviour as Glen in Excel 2010 beta
best wishes

 

[Opal]

It used to repeat just 12 and 13 and now all of a sudden
and I don't know why, it is repeating 1 - 13.

 

[Gord Dibben]

Same in 2003 and 2007

I misspoke.

Rows 12 and 13 won't appear as repeating on first page but will on each
successive page.

Right as always...............NOT! <g>


Gord

 

[Opal]

??

Yes, they used to repeat and suddenly not...not sure why
or how this happened, but I can't get these rows to repeat
anymore.

 

[Glenn]

??

Yes, they used to repeat and suddenly not...not sure why
or how this happened, but I can't get these rows to repeat
anymore.

Make sure you have only this one worksheet selected, then go to File / Page
Setup / Sheet / Rows to repeat at top: and enter $12:$13. When you print (or
Print Preview), what is the result?

 

[Opal]

the result is

Page 1

Rows 1 - 21

Page 2

Rows 1 - 9, 22-29

 

[Glenn]

the result is

Page 1

Rows 1 - 21

Page 2

Rows 1 - 9, 22-29

Makes no sense. If you want, and if the workbook is less than 1mb, email it to
me at schwandtg at aol dot com and I'll take a look at it.

 

[Opal]

Thanks, I wish I could, but the information in it
is proprietary. The only thing we were thinking
was maybe our IS Dept has failed to install
a Microsoft update..... :-(

 

[Opal]

I came up with a work around.

Utilizing the following placed in ThisWorkbook
from Ron DeBruin

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet 1" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
.Rows("22:23").EntireRow.Hidden = False
.PrintOut
.Rows("22:23").EntireRow.Hidden = True
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub

I copied rows 12:13 to 22:23 where I need them
and used the above code. It works. The only issue
I will have is if the rows increase on page one of the
report I may have to adjust where I put 22:23.