Repeating Rows and Columns on every page

B

BruceM

I have a problem formatting my report in the way I would like to.

I want to repeat the top 10 rows and the first 4 columns of my report on
each page when I print it (therefore the text I want repeated makes an upside
down L shape)

I know that I need to do the following:

Rows to repeat: $1:$10
Columns to repeat: $A:$D

However, the report 'headings' in the first 10 rows include merged cells
(e.g I merge 6A - 6T). This causes a problem in the printed version of the
report, as any header text which is not 'alligned' with columns A-D will not
appear on any page other than the first page.

Only the text alligned with columns A-D is repeted on each page - the other
text that I want to see from the first 10 rows is not vissible

Is it possible to get round this without using the actual 'Headers' facility?

Thanks in advance
 

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

Similar Threads

Repeating a row other than the 1st row as the header row in a table from next page 1
Space at end of multi page list to accommodate new entries 1
Page numbering with Merged Document and IF statements 1
Repeating Rows and Columns on each page of print out 1
Format column widths from one table to a separate table on same page 1
"Repeat Rows" - selected printed pages only 3
Rows to repeat at top... Help... 1
How can I print rows that go outside of the page without shrinking the text? 0

Top