Repeating rows dont repeat fully when columns also repeat

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
 
D

Dave Peterson

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.
 
D

dranon

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

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.

As per above.

Thanks for the respose.
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top