Results 1 to 13 of 13
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Print areas (2003)

    <P ID="edit" class=small>(Edited by robm on 14-Jan-09 11:45. forgot to add picture)</P>Attatched is a screenshop of a spreadsheet I have. All the areas surrounded by green, I need to print onto a single sheet. The yellow area contains formulas, and I need it to be visible, but can't hide the few colums of the spreadsheet, without hiding this area also, which I don't want to do. Is there a way of printing just the areas surrounded by green? Apparently, 2007 does it.
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print areas (2003)

    Create a new sheet, and use formulas of the form =OtherSheet!A1 to link to the cells you want to print.

    (You can define a non-contiguous print area in Excel 2003, but each area will become a separate page in the printout, which is not what you want.)

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: Print areas (2003)

    On a new sheet (or where you have plenty of space), use the Excel Camera tool to 'snapshot' the different areas you want to print on a single page.
    Using the camera tool, you don't have to worry about formatting, different column widths or anything else.
    The camera tool is like having multiple personal CCTVs aimed at different spreadsheet ranges.
    Whenever data in the source range changes, this is immediately shown in the CCTV 'image'.

    It is a fantastic under-used feature of Excel.

    zeddy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print areas (2003)

    Good suggestion!

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print areas (2003)

    Hi Zeddy
    <hr>use the Excel Camera tool <hr>
    I have never heard of this before and cannot locate it. Any polite suggestions? <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>
    Regards
    Don

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print areas (2003)

    You can add it to a toolbar as follows:
    - Select Tools | Customize...
    - Activate the Commands tab.
    - Select Tools in the list of Categories on the left hand side.
    - Scroll down the list of Commands on the right hand side until you see the Camera icon.
    - Drag the camera to a convenient location on a toolbar. (I've placed it in the Cut/Copy/Paste group.)

    Use it as follows:
    - Select a range. This range may include graphic objects such as pictures and charts.
    - Click the Camera tool.
    - If desired, activate another sheet, or even another workbook.
    - Click where you want a picture of the selected range.
    - The picture is linked to the source - any change in the source will be reflected in the picture.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Print areas (2003)

    The Camera tool is not available, by default, on any Excel toolbar. Instead, you need to add it to a toolbar.

    Tools - Customize and make sure the Commands tab is displayed.

    In the list of Categories, choose Tools,
    Scroll through the Commands list until you find Camera. (it has a small camera icon to the left of the command.)
    Drag the Camera command to a toolbar and drop it there.
    Close the Customize dialog box, and you are ready to use the Camera tool.

    Steve

  8. #8
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print areas (2003)

    Thank you Steve <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    Regards
    Don

  9. #9
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print areas (2003)

    An alternate method to use the Camera function would be to copy the ranges as normal then hold the shift key while choosing Edit on the menu bar.

    Attachment shows the alternate menu under Edit when pressing shift. Copy is replaced with Copy Picture and Paste Special... is replaced with Paste Picture and Paste Picture Link.
    Attached Images Attached Images

  10. #10
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print areas (2003)

    Thank you Mike.
    Regards
    Don

  11. #11
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Print areas (2003)

    Thanks guys for all your suggestions. It's something I have to print off every month. I used Hans suggestion this time round, but I'll certainly look at the others for next time. Thanks again.

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print areas (2003)

    Robm, thanks for raising this question.
    Zeddy , thanks for telling me/us about the Camera.
    Don, thanks for asking the question I was afraid to ask.
    Hans, thanks for fixing that broken link in my posting a few years back (grin!)

  13. #13
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: Print areas (2003)

    If you use the Excel Camera (which I love) beware of taking 'snapshots' of cell ranges which may include a large number of hidden columns or rows.
    Excel's camera can run out of 'film'.

    The Camera tool is very useful for consolidating lots a information onto a single printable sheet, without having to worry about the underlying sheet's formatting, column width set-up etc.


    zeddy

Posting Permissions

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