double sided printing

[Jeff Donahue]

At our office we have a printer that does double sided
printing. We are trying to set up our reports to print
out double sided. The problem that we seem to be having
is that Excel treats each worksheet as a new print job and
therefore we can not seem to find a way to get Excel to
print one worksheet on one side of the page and the next
worksheet on the other side.

If you have two pages in one worksheet then you can get
those to print double sided but the problem there is that
Excel then assigns these two pages the same page number.

So my question is this... Is there any way to get Excel to
print double sided with each worksheet on one side, which
may mean is there any way to get Excel to NOT treat each
worksheet as a different print job?

Any help that you can provide would be greatly appreciated.

Thanks in advance

Jeff Donahue

 

[Dave Peterson]

Untested (I don't have a duplex printer to try it with):

What happens if you click on the first worksheet tab and ctrl-click on the
second. Then print the selected sheets?

This is called grouping and you'll see that excel tries to warn you that your
worksheets are grouped by putting [Group] in the title bar. Anything you do to
one of these grouped sheets, you do to the other. So ungroup them (rightclick

 

[Jeff Donahue]

Yeah, we tried this but what ends up happening is that you
get each worksheet printed on a separate piece of paper.
Excel treats each worksheet in a workbook as a separate
print job, which is really where my problem lies and I am
trying to find a way to bypass this.

Thanks

Jeff

-----Original Message-----
Untested (I don't have a duplex printer to try it with):

What happens if you click on the first worksheet tab and ctrl-click on the
second. Then print the selected sheets?

This is called grouping and you'll see that excel tries to warn you that your
worksheets are grouped by putting [Group] in the title bar. Anything you do to
one of these grouped sheets, you do to the other. So ungroup them (rightclick

At our office we have a printer that does double sided
printing. We are trying to set up our reports to print
out double sided. The problem that we seem to be having
is that Excel treats each worksheet as a new print job and
therefore we can not seem to find a way to get Excel to
print one worksheet on one side of the page and the next
worksheet on the other side.

If you have two pages in one worksheet then you can get
those to print double sided but the problem there is that
Excel then assigns these two pages the same page number.

So my question is this... Is there any way to get Excel to
print double sided with each worksheet on one side, which
may mean is there any way to get Excel to NOT treat each
worksheet as a different print job?

Any help that you can provide would be greatly appreciated.

Thanks in advance

Jeff Donahue

--

Dave Peterson
(e-mail address removed)
.

 

[Dave Peterson]

I just grouped two worksheets. I hit the print button. I looked at the print
queue and saw one print job.

Yeah, we tried this but what ends up happening is that you
get each worksheet printed on a separate piece of paper.
Excel treats each worksheet in a workbook as a separate
print job, which is really where my problem lies and I am
trying to find a way to bypass this.

Thanks

Jeff

-----Original Message-----
Untested (I don't have a duplex printer to try it with):

What happens if you click on the first worksheet tab and ctrl-click on the
second. Then print the selected sheets?

This is called grouping and you'll see that excel tries to warn you that your
worksheets are grouped by putting [Group] in the title bar. Anything you do to
one of these grouped sheets, you do to the other. So ungroup them (rightclick

At our office we have a printer that does double sided
printing. We are trying to set up our reports to print
out double sided. The problem that we seem to be having
is that Excel treats each worksheet as a new print job and
therefore we can not seem to find a way to get Excel to
print one worksheet on one side of the page and the next
worksheet on the other side.

If you have two pages in one worksheet then you can get
those to print double sided but the problem there is that
Excel then assigns these two pages the same page number.

So my question is this... Is there any way to get Excel to
print double sided with each worksheet on one side, which
may mean is there any way to get Excel to NOT treat each
worksheet as a different print job?

Any help that you can provide would be greatly appreciated.

Thanks in advance

Jeff Donahue

--

Dave Peterson
(e-mail address removed)
.

 

[Jeff Donahue]

Yes, it treats it as one print job but treats each
worksheet as a separate page for some reason.

-----Original Message-----
I just grouped two worksheets. I hit the print button. I looked at the print
queue and saw one print job.

Yeah, we tried this but what ends up happening is that you
get each worksheet printed on a separate piece of paper.
Excel treats each worksheet in a workbook as a separate
print job, which is really where my problem lies and I am
trying to find a way to bypass this.

Thanks

Jeff

-----Original Message-----
Untested (I don't have a duplex printer to try it with):

What happens if you click on the first worksheet tab

and
ctrl-click on the

second. Then print the selected sheets?

This is called grouping and you'll see that excel tries to warn you that your
worksheets are grouped by putting [Group] in the title bar. Anything you do to
one of these grouped sheets, you do to the other. So ungroup them (rightclick
on the tab|Ungroup sheets), before you do anything more.



Jeff Donahue wrote:

At our office we have a printer that does double sided
printing. We are trying to set up our reports to print
out double sided. The problem that we seem to be having
is that Excel treats each worksheet as a new print

job
and

therefore we can not seem to find a way to get Excel to
print one worksheet on one side of the page and the next
worksheet on the other side.

If you have two pages in one worksheet then you can get
those to print double sided but the problem there is that
Excel then assigns these two pages the same page number.

So my question is this... Is there any way to get

Excel
to

print double sided with each worksheet on one side, which
may mean is there any way to get Excel to NOT treat each
worksheet as a different print job?

Any help that you can provide would be greatly appreciated.

Thanks in advance

Jeff Donahue

--

Dave Peterson
(e-mail address removed)
.

--

Dave Peterson
(e-mail address removed)
.

 

[Jay]

At our office we have a printer that does double sided
printing. We are trying to set up our reports to print
out double sided. The problem that we seem to be having
is that Excel treats each worksheet as a new print job and
therefore we can not seem to find a way to get Excel to
print one worksheet on one side of the page and the next
worksheet on the other side. ...

... Is there any way to get Excel ... NOT treat each
worksheet as a different print job?

Any help that you can provide would be greatly appreciated.

With Excel alone, I don't know a solution.

But there's a separate program, FinePrint, from
http://www.fineprint.com/
that (among its many features) merges multiple print jobs.