Print Titles: Repeating both left column and top rows

[rsandow]

I'm stumped. For some reason I cannot get both left columns and rows to
print on following pages. If I select Top only, it won't print on following
pages at all. If I select the left columns, it will print on subsequent
pages but only the text in cols 1 & 2. The top rows contain written text
spanning 6 columns. If I select both top rows and left columns to repeat, I
get the same result as in selecting just left columns. I checked the cells
in the "problem" row and there are no hidden items that might prevent the row
from printing properly.

 

[Sheeloo]

Choose a blank Sheet
Enter this in A1
="Row: " &ROW()&" Col: "&COLUMN()

Now select row 1 as 'rows to repeat at top'
and col 1 as 'column to repeate at left'

Does it work for you?

If yes, then go back to your sheet and verify that there is actually
something to print..

 

[Fred Smith]

Go to Page Setup>Sheet

In Rows to Repeat at Top, enter $1:$2 (adjust to suit your situation)
In Columns to repeat at left, enter $A:$F (adjust to suit)

OK out.

Regards,
Fred.