Ask a Question Sign up for Free 125 Experts currently online. Ask Questions for Free!

Print on Both Sides - Excel Printing

I am trying to print one page from two worksheets on the same paper - front to back. Can anybody help me with this problem? My printer setting is on print on both sides but I always get two separate peaces of paper. Can this be done? Thanks....

Results 1 to 7 of 7

  1. #1

    Print on Both Sides

    I am trying to print one page from two worksheets on the same paper - front
    to back. Can anybody help me with this problem?
    My printer setting is on print on both sides but I always get two separate
    peaces of paper.
    Can this be done?

    Thanks.


    Vlad
  2. #2

    Re: Print on Both Sides

    I think that would be by design, similar to keeping chapters
    starting on an odd page (front side of paper). I can't imagine
    it being any other way.

    There would be a lot more problems if it were otherwise.

    I don't have access to a duplex printer and never was a server
    administrator, it might be possible to change things. At least
    you're not getting cover sheets between everything like in an office.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Vlad" <com> wrote ... 


    David
  3. #3

    Re: Print on Both Sides

    Are you reinserting the page with side 1 printed on it back into the printer
    so side 2 can print on the reverse side?


    Richard
  4. #4

    Re: Print on Both Sides

    Let me restate my problem. I select two worksheets by holding shift key
    down and then want to print duplex. When print-previewing I only see two
    pages but when printing then I get two sheets instead of one printed on both
    sides.
    Thanks.


    "Vlad" <com> wrote in message
    news:TNPnc.735$news.prodigy.com... 
    front 


    Vlad
  5. #5

    Re: Print on Both Sides

    If you printed 3 copies of an odd number of pages.
    You would not want the 2nd and 3rd copy to print
    on the back of the last page of the previous copy.

    Nor would you want your printout on the back of
    someone else's printout, so I think with Duplex
    printing have to go with such settings. But you
    might check if there are additional options that
    apply for duplex printing for both the printer and
    on the server like where one might select
    separation pages...

    Like chapters in a book I previously mentioned they
    start on the front (odd page numbe) side of a sheet.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Vlad" <com> wrote in message news:uT3oc.6287$news.prodigy.com... 


    David
  6. #6

    Re: Print on Both Sides

    Thanks David,
    For now my solution is to print to PDF and than I can print on both sides.
    "David McRitchie" <com> wrote in message
    news:%phx.gbl... 
    news:uT3oc.6287$news.prodigy.com... 
    two 
    both 
    separate 


    Vlad
  7. #7

    Re: Print on Both Sides

    http://support.microsoft.com/default.aspx?scid=kb;en-us;214383

    Best i have found so far. I have the same problem. When I use the adobe
    method, it creates multiple files.

    "Vlad" <com> wrote in message
    news:TNPnc.735$news.prodigy.com... 
    front 


    Jay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100