[SOLVED] How do I print two worksheets front and back?

[Jeri]

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?

[Jeri]

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]

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

[Jeri]

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]

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

[Bryan Hessey]

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).

[Jeri]

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
>
>

[minal190]

Thank you so much.

[Mrstyles84]

the best way to achieve a double sided print is to select you two sheets using CTRL, and from there the print the function automatically picks up the two sheets as separate pages
i personally set up specific printing conditions using this method though as it can muck around with headers and footers if you have any