ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel, how do I print the workbook sheets to 2sided paper? (https://www.excelbanter.com/excel-discussion-misc-queries/36039-excel-how-do-i-print-workbook-sheets-2sided-paper.html)

workfirst

In Excel, how do I print the workbook sheets to 2sided paper?
 
I can't get the 2 sheets in the workbook to print out on both sides of a
printed sheet. I select "entire workbook" from print menu and "preferences"
to 2 sided paper, but it prints each sheet separately.
Using excel 2003 in Microsoft Office
Thanks!

Ron de Bruin

Hi workfirst

This is a printer setting so if your printer not support this it will not work.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
I can't get the 2 sheets in the workbook to print out on both sides of a
printed sheet. I select "entire workbook" from print menu and "preferences"
to 2 sided paper, but it prints each sheet separately.
Using excel 2003 in Microsoft Office
Thanks!




workfirst

Thanks Ron - my printer does support 2 sided printing. I chose that under
preferences as I usually do for 2 sided printing, however, it is printing
sheet 1 and then sheet 2 on a separate paper. I would like sheet 1 to be on
one side of the paper and sheet 2 on the other side. (Each are just a single
page in length.)
Is this possible?
Thanks,
workfirst

"Ron de Bruin" wrote:

Hi workfirst

This is a printer setting so if your printer not support this it will not work.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
I can't get the 2 sheets in the workbook to print out on both sides of a
printed sheet. I select "entire workbook" from print menu and "preferences"
to 2 sided paper, but it prints each sheet separately.
Using excel 2003 in Microsoft Office
Thanks!





Ron de Bruin

I can't test itfor you but if you select both sheets (group) and hit the print button
is it working then?

Don't forget to ungroup


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
Thanks Ron - my printer does support 2 sided printing. I chose that under
preferences as I usually do for 2 sided printing, however, it is printing
sheet 1 and then sheet 2 on a separate paper. I would like sheet 1 to be on
one side of the paper and sheet 2 on the other side. (Each are just a single
page in length.)
Is this possible?
Thanks,
workfirst

"Ron de Bruin" wrote:

Hi workfirst

This is a printer setting so if your printer not support this it will not work.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
I can't get the 2 sheets in the workbook to print out on both sides of a
printed sheet. I select "entire workbook" from print menu and "preferences"
to 2 sided paper, but it prints each sheet separately.
Using excel 2003 in Microsoft Office
Thanks!







workfirst

I grouped them and then printed, choosing 2 sided, but they still came out
separately on one side of 2 pages....

"Ron de Bruin" wrote:

I can't test itfor you but if you select both sheets (group) and hit the print button
is it working then?

Don't forget to ungroup


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
Thanks Ron - my printer does support 2 sided printing. I chose that under
preferences as I usually do for 2 sided printing, however, it is printing
sheet 1 and then sheet 2 on a separate paper. I would like sheet 1 to be on
one side of the paper and sheet 2 on the other side. (Each are just a single
page in length.)
Is this possible?
Thanks,
workfirst

"Ron de Bruin" wrote:

Hi workfirst

This is a printer setting so if your printer not support this it will not work.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
I can't get the 2 sheets in the workbook to print out on both sides of a
printed sheet. I select "entire workbook" from print menu and "preferences"
to 2 sided paper, but it prints each sheet separately.
Using excel 2003 in Microsoft Office
Thanks!







Ron de Bruin

Hi workfirst

I hope someone with a printer like you can test it for you and give you a answer
Good luck


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
I grouped them and then printed, choosing 2 sided, but they still came out
separately on one side of 2 pages....

"Ron de Bruin" wrote:

I can't test itfor you but if you select both sheets (group) and hit the print button
is it working then?

Don't forget to ungroup


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
Thanks Ron - my printer does support 2 sided printing. I chose that under
preferences as I usually do for 2 sided printing, however, it is printing
sheet 1 and then sheet 2 on a separate paper. I would like sheet 1 to be on
one side of the paper and sheet 2 on the other side. (Each are just a single
page in length.)
Is this possible?
Thanks,
workfirst

"Ron de Bruin" wrote:

Hi workfirst

This is a printer setting so if your printer not support this it will not work.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
I can't get the 2 sheets in the workbook to print out on both sides of a
printed sheet. I select "entire workbook" from print menu and "preferences"
to 2 sided paper, but it prints each sheet separately.
Using excel 2003 in Microsoft Office
Thanks!









workfirst

Thank you Ron.
I'm using a Canon imageRUNNER 3320N
Appreciate your suggestions...

"Ron de Bruin" wrote:

Hi workfirst

I hope someone with a printer like you can test it for you and give you a answer
Good luck


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
I grouped them and then printed, choosing 2 sided, but they still came out
separately on one side of 2 pages....

"Ron de Bruin" wrote:

I can't test itfor you but if you select both sheets (group) and hit the print button
is it working then?

Don't forget to ungroup


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
Thanks Ron - my printer does support 2 sided printing. I chose that under
preferences as I usually do for 2 sided printing, however, it is printing
sheet 1 and then sheet 2 on a separate paper. I would like sheet 1 to be on
one side of the paper and sheet 2 on the other side. (Each are just a single
page in length.)
Is this possible?
Thanks,
workfirst

"Ron de Bruin" wrote:

Hi workfirst

This is a printer setting so if your printer not support this it will not work.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"workfirst" wrote in message ...
I can't get the 2 sheets in the workbook to print out on both sides of a
printed sheet. I select "entire workbook" from print menu and "preferences"
to 2 sided paper, but it prints each sheet separately.
Using excel 2003 in Microsoft Office
Thanks!











All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com