Repeating Rows and Columns on each page of print out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Actually the best bet is to not merge cells.
Really I think all of us have been bit by some of the oddities which happen
when you merge.
 

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 only a portion of both row and column on multiple pages 1
Print Titles - Columns to Repeat at Left 1
Repeating first Row AND first column on every page 1
Print Titles: Repeating both left column and top rows 2
REPEAT ROW HEADINGS ON EACH PAGE 1
Access Page Header with merge field 0
print setup -columns to repeat 2
Repeating Rows 1

Back
Top