Excel print titles

I

I Am Cdn

I have a 12 mth spreadhseet with Jan to Dec running left to right. On the
very right I have a Totals column.

in col A I have names

I have set Print titles for Col A as well as rows 1 to 3

I have the page breaks set for each three month quarterly grouping.

Is there some way that I can get the "TOTALS" column (Which is on the last
page) to also print as a "Title" column but on the right hand side of each of
the preceding 3 pages?

Thanks

[email protected]
 
D

David McRitchie

No sure that I understand your layout or the content but if your
Total is in Cell M15 couldn't you use something like

L1: 'Total for YTD: (right justified)
M1: =M15

then with your former row 1 on Row 2 you would use
Rows to repeat at top: $1:$2 instead of $1:$1
 
Top