#1   Report Post  
I Am Cdn
 
Posts: n/a
Default 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


  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up print titles in Excel? ON1 Excel Worksheet Functions 1 February 22nd 05 03:11 PM
I faxed an excel worksheet and now cannot print? C. P. Excel Worksheet Functions 2 February 21st 05 09:28 PM
How can you print file properties in an Excel spreadsheet? RSG Excel Discussion (Misc queries) 1 February 21st 05 08:33 PM
Set "print all text as black" as default in Excel CMK Excel Worksheet Functions 0 January 25th 05 08:31 PM
Microsoft Excel could not find anything to print cyndi Excel Discussion (Misc queries) 1 December 22nd 04 01:40 PM


All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"