Repeating rows dont repeat fully when columns also repeat

  • Thread starter Thread starter dranon
  • Start date Start date
D

dranon

I am repeating rows 1 through 4 and columns A through D. At least
that is what I'm trying to do. On page two, the columns repeat but
then the rows do not (beyond columns A through D). Is there a way to
make it so that they both repeat?

In re-reading the above, I'm not sure I'm making myself clear.

Assume that XX's represent the repeating rows and ZZ's represent the
repeating columns. This is what I'd like to see:

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY

That is, the information represented by the Y's is contained in
columns beyond A through D. On the first page it would be columns E
through H and the second page it would be I through L, etc.

The first page does, in fact, print like the above. But the second
page prints as follows:

XXXXXXXXXXX YYYYYYYYYYYYYYYYYYYYYY
XXXXXXXXXXX YYYYYYYYYYYYYYYYYYYYYY
XXXXXXXXXXX YYYYYYYYYYYYYYYYYYYYYY
XXXXXXXXXXX YYYYYYYYYYYYYYYYYYYYYY

ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY

I suppose there is no way around this (other than putting all the
information in XX into a custom header).

Thanks
 
On the second page, you should be seeing the headers in A1:D4 and I1:L4

If that's not what you're seeing, maybe you could explain again what you're
seeing--or explain what you'd want to see.
 
On the second page, you should be seeing the headers in A1:D4 and I1:L4
Click to expand...

I am and I don't want that. I want A1:H4 to show up in the first four
rows.
If that's not what you're seeing, maybe you could explain again what you're
seeing--or explain what you'd want to see.
Click to expand...

As per above.

Thanks for the respose.
 
I think you'll have to try to do what you want with the sheet header--not the
rows to repeat at top.
 
Back
Top