Excel print titles

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

Guest

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

(e-mail address removed)
 
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
 

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

Back
Top