Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Charlotte, North Carolina, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Side By Side Pages

    In Excel 97 or 2000, is there any way to print 2 pages side by side on the same sheet of paper (like you can in Word with WOPR)?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Printing Side By Side Pages

    There is no inbuilt way but you could use a workaround. Set up a link on a separate sheet which contain references to the two pages you want to print. It might be a good idea to leave a narrow column between the two pages. Set the page orientation to landscape and set the scaling to 1 page(s) Wide by 1 tall. Set the margins to suit and center horizontally and vertically. It is a bit convoluted, but the best way I know without recourse to even more convoluted macros.

    Andrew C

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Side By Side Pages

    Use the camera (Tools menu/Customise/Commands/Tools, and drag the camera onto a toolbar). Select your first sheet, click on the camera, go to a blank sheet and drop and size a copy onto this sheet. Repeat for the second sheet.

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Printing Side By Side Pages

    Thanks for the tip. I've never used the camera before, but it works great.

Posting Permissions

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