+ Reply to Thread
Results 1 to 7 of 7

Print two worksheets as one print job

  1. #1
    Registered User
    Join Date
    05-02-2008
    Location
    UK
    Posts
    6

    Print two worksheets as one print job

    I'm trying to print two sheets within the same workbook at the same time as a single print job. This way sheet1 is the front and sheet2 the back.

    It I do select both sheets and then print active sheets Excel creates two print jobs, forcing the printer to start the second sheet on a new page.

    This page break between the prints means that I have two single sheets printed out of the printer rather than one piece of paper in duplex.

    Any ideas on a work around for this?

    The two two sheets are only a sinlge page in size, but have different column widths so wont easily go onto a single worksheet.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hi,

    This needs to be set up using your printer, assuming it does duplex printing?

    http://exceltips.vitalnews.com/Pages..._Printing.html
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    05-02-2008
    Location
    UK
    Posts
    6
    Thats for the reply, but its not as simple as that.

    The printer is already set as duplex. Excel is creating a new print job for each worksheet, when really I want each sheet to be a continuation of the first worksheet print job.

    (If it was a printer setting then the printer would sit there waiting for the duplex side each time and you would end up with all sorts of issues with other applications prints on the back of other printer users work.)

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    The two two sheets are only a sinlge page in size, but have different column widths so wont easily go onto a single worksheet.
    Can you not copy the second sheet and put it on the right side (in some blank columns) of the first sheet so that they are side-by-side?

  5. #5
    Registered User
    Join Date
    05-02-2008
    Location
    UK
    Posts
    6
    Thanks again.

    Thats what I was trying to avoid as I dont really own the sheet. I was hoping for some whizzy way to get round this.

    Regards,

  6. #6
    Registered User
    Join Date
    06-17-2008
    Posts
    1

    Try this...

    I did not think that this would work, but it did, for me:

    http://support.microsoft.com/kb/169033

  7. #7
    Registered User
    Join Date
    06-17-2008
    Posts
    1

    Smile mk1

    THANKS mk1. Your link explaining that you have to set each sheet to duplex printing helped! I knew there were still some smart people in the world.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1