Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplex printing multiple tabs (Excel 2003)

    Perhaps I'm missing it on a search of this forum, but I don't see this addressed.

    Is it still possible in Excel 2003 to print multiple tabs in duplex fashion (tab 1 of worksheet prints on sheet 1, tab 2 prints on back of sheet 1) etc? I can't seem to do it. Whether I try "print workbook" or "print active sheets", highlighting both sheets, and choosing duplex options -- it still puts each tab on a separate piece of paper.

    Did they take out that feature?

    pribb

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplex printing multiple tabs (Excel 2003)

    It works for me in XL2K. The way I have to do it is to select each sheet one at a time and go to print that sheet. While in the print dialog, select properties and set the "Print on both sides" (or whatever it is called for your printer driver) property. Then close the print dialog box without printing the sheet. After you have done this for all sheets, then select all of the sheets that you want to print duplex and print them. In my XL2K, they print as you describe. If you save the workbook after doing this, the "Print on both sides" is remembered.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplex printing multiple tabs (Excel 2003)

    Thanks Legare,

    Yeah, I think I figured that out when I finally found this article:
    http://support.microsoft.com/default.aspx?...kb;en-us;169033

    Apparently what I was missing was that you have to set up the page setup/print options ON EACH SHEET, or each tab, separately. I made it work in 2000, now I'm going to try it in 2003
    (I'm just the helpdesk, trying to figure this out for a user)

    pribb

Posting Permissions

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