Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up print titles in Excel? | Excel Worksheet Functions | |||
I faxed an excel worksheet and now cannot print? | Excel Worksheet Functions | |||
How can you print file properties in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Set "print all text as black" as default in Excel | Excel Worksheet Functions | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) |