excel 2007 printing

Discussion in 'OT Technology' started by 1999TL, Oct 7, 2008.

  1. 1999TL

    1999TL New Member

    Sep 22, 2006
    Likes Received:
    Lubbock, TX
    Say I have some sheets in excel that are in different files. I have to do lists for week 1-12 for something. Each one is saved in a different file. I want to print it all out at once so that I can take advantage of duplex printing. Is there a way to make Excel print out all my sheets at once so that I dont have to print one by one, while manually turning over the pages after each sheet so that I can print on both sides?
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Mar 14, 2000
    Likes Received:
    Vancouver, BC, CANADA
    In Excel 2003, there's an option in the print dialog that allows you to print the entire workbook.

    Edit: Oh - just simply print to PDF and join them. I use PDFCreator. You can turn off the "printer" so it send all the print jobs to it but doesn't prompt you to save them, then combine them, turn it back on and then save them as one PDF document. Then print the PDF document.
    Last edited: Oct 7, 2008

Share This Page