A Printing Question
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: A Printing Question

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I know how to make columns repeat themselves at the left of the page when printing. But is there a way to make a column repeat on the right side of the page also? IE have a totals column repeat on each page along with a title column still repeating on the left. Any help is much appreciated.




  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can't do it with PageSetup, but maybe one of the gurus knows a way around it.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Al,

    You would think MS, would have that option, seems pretty obvous to me, maybe it will be a new feature in Excel-XP-V12...

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-20 11:29, kluitna wrote:
    I know how to make columns repeat themselves at the left of the page when printing. But is there a way to make a column repeat on the right side of the page also? IE have a totals column repeat on each page along with a title column still repeating on the left. Any help is much appreciated.
    you did say *any* help :

    if you can spare the page width, how about taking a snapshot of the column and pasting it on the right to each page you want printed
    ?

    it's the camera icon, in view / toolbars / customise / commands / tools


    :: Pharma Z - Family drugstore ::

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Chris:
    Thanks for this tip ... GREAT! I have brought the camera icon on one of the tool bars -- now I have to find ways of using it gainfully. T H A N K S !

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    *chuckle*

    I use it to take snapshots of different parts of the worksheet..... say, summary data ranges where all the column widths are different

    you can then just pop the snapshots onto a single sheet and not have to worry about different column widths or anything as they are pictures and will align up perfectly, say if it's an overall summary sheet, maybe in a memo style

    (I have to echo Jack here - "Word sucks"... I do all my Word stuff in Excel. In fact, Word really does suck.)

    they are also "realtime", in so far as they update themselves when the scource data is updated

    Glad it found a use !

  7. #7
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Chris:
    Thanks for some more insight into the use of the CAMERA Option. I have another question for you. Do you use the Copy_Picture Paste_Picture in Excel (taking picture this way is static), whereas the CAMERA Picture is dynamic.
    Any other comments on comparable features and pros and cons on the use of one versus the other!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    (I have to echo Jack here - "Word sucks"... I do all my Word stuff in Excel. In fact, Word really does suck.)


    To add i always end in crossed words over this but excel has weeknesses, like text upside down can not be done, erm no it kinda can a pal Ivan F Moala solved that one!

    mail merge,, cant be done .. erm yes its can merge is just batch work all the same... simple vlookup will do. but what of different data say debt owed not so sinmple Ok merge can roll on click the user numbers and bigo debt input

    SLOOOOOWWW!

    In VBA you can do about 100 to 120 different letter s in a minute well i can and i do all in excel.. no different asnd effort free

    I designed the code and evelop it....

    what else??? Im stuck!

    excel wins

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  9. #9
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Jack for the real world experience information with Excel!

  10. #10
    Board Regular
    Join Date
    Apr 2002
    Location
    Alberta, Canada
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Try making a print macro with the following code inserted at the beginning of the macro code

    With ActiveSheet.PageSetup
    .PrintTitleRows = ""
    .PrintTitleColumns = "enter columns to be printed at the edge of each sheet here"
    End With

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com