Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I print two worksheets front and back?
I have never had a troubleshooting problem, but this one has baffled me. I
have two simple worksheets, and I am having the worst trouble printing each worksheet front and back (2 sided). I will set the printing options to 2 sided, make sure it's printing the 'entire workbook', and it still comes out on seperate pages. Any suggestions? |
#2
|
|||
|
|||
This is in Excel. I forgot to include that minor detail :)
each worksheet is 1 page. I have yet to find a solution to this problem after searching 'help' and forums.. "Jeri" wrote: I have never had a troubleshooting problem, but this one has baffled me. I have two simple worksheets, and I am having the worst trouble printing each worksheet front and back (2 sided). I will set the printing options to 2 sided, make sure it's printing the 'entire workbook', and it still comes out on seperate pages. Any suggestions? |
#3
|
|||
|
|||
How about printing one sheet, catching the hardcopy, turn it over and printing
the second sheet. Jeri wrote: This is in Excel. I forgot to include that minor detail :) each worksheet is 1 page. I have yet to find a solution to this problem after searching 'help' and forums.. "Jeri" wrote: I have never had a troubleshooting problem, but this one has baffled me. I have two simple worksheets, and I am having the worst trouble printing each worksheet front and back (2 sided). I will set the printing options to 2 sided, make sure it's printing the 'entire workbook', and it still comes out on seperate pages. Any suggestions? -- Dave Peterson |
#4
|
|||
|
|||
Printing 100 copies that way would take twice as long.. I was looking for a
short cut. Thanks "Dave Peterson" wrote: How about printing one sheet, catching the hardcopy, turn it over and printing the second sheet. Jeri wrote: This is in Excel. I forgot to include that minor detail :) each worksheet is 1 page. I have yet to find a solution to this problem after searching 'help' and forums.. "Jeri" wrote: I have never had a troubleshooting problem, but this one has baffled me. I have two simple worksheets, and I am having the worst trouble printing each worksheet front and back (2 sided). I will set the printing options to 2 sided, make sure it's printing the 'entire workbook', and it still comes out on seperate pages. Any suggestions? -- Dave Peterson |
#5
|
|||
|
|||
Print once and visit the copier?
Jeri wrote: Printing 100 copies that way would take twice as long.. I was looking for a short cut. Thanks "Dave Peterson" wrote: How about printing one sheet, catching the hardcopy, turn it over and printing the second sheet. Jeri wrote: This is in Excel. I forgot to include that minor detail :) each worksheet is 1 page. I have yet to find a solution to this problem after searching 'help' and forums.. "Jeri" wrote: I have never had a troubleshooting problem, but this one has baffled me. I have two simple worksheets, and I am having the worst trouble printing each worksheet front and back (2 sided). I will set the printing options to 2 sided, make sure it's printing the 'entire workbook', and it still comes out on seperate pages. Any suggestions? -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
Because each worksheet is it's own separate print (with it's own 'Set Print Area' etc) you cannot have them considered for duplexing together. Two (or more) worksheets can be duplexed by printing to Acrobat Distiller and printing the resultant .pdf file to the duplex printer, this would be the 'quick-and-easy' method for you, printing once from Excel and copies = 100 from Adobe (if you have Adobe Acrobat or similar program). -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390586 |
#7
|
|||
|
|||
Thank you very much. This was very helpful. I ended up just making two pages
on one worksheet and printing two sided. It works! That way it is also saved with those settings. Thanks for the help! "Bryan Hessey" wrote: Because each worksheet is it's own separate print (with it's own 'Set Print Area' etc) you cannot have them considered for duplexing together. Two (or more) worksheets can be duplexed by printing to Acrobat Distiller and printing the resultant .pdf file to the duplex printer, this would be the 'quick-and-easy' method for you, printing once from Excel and copies = 100 from Adobe (if you have Adobe Acrobat or similar program). -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390586 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print excel worksheets double sided | Excel Worksheet Functions | |||
How can I put cells in front of a picture? | Excel Discussion (Misc queries) | |||
message configure office xp with front page | Excel Discussion (Misc queries) | |||
How do I print row labels on alternating pages of an Excel workshe | Excel Discussion (Misc queries) | |||
how do I tell excell 2003 to print sheets back to front? | Excel Discussion (Misc queries) |