Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    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!

    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    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


Posting Permissions

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