Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing to one page (2003 SP2)

    Somewhat of a simple question but I can't figure it out. On the attached spreadsheet, I'd like the highlighted (Print Area) to print Portrait with columns AH to AP on top and AQ to AY on the bottom, basically all of it on one page but not squeezed together on the top. I've already tried playing with all the Page Setup settings such as Sheet/Page Order and the Printer settings for print two pages to a page etc and nothing is working. If someone has a quick answer, it would be extremely appreciated!

    Thanks.
    Pooja
    Attached Files Attached Files

  2. #2
    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: Printing to one page (2003 SP2)

    There is no "built-in" way in excel. As described at ExcelTips: Multiple Print Areas on a Single Printed Page there are some workarounds:
    Some printers have this capability as described at
    Another option is to recreate the page in the format desired.with the second series below the first
    Another option is to use the camera tool to take pictures of the various regions and place them in a new sheet

    Steve

Posting Permissions

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