Excel print titles
 

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

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"I Am Cdn" wrote in message ...
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