Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
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! |
#6
|
|||
|
|||
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! |
#7
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
How can I delete similar rows in excel workbook with many sheets? | Excel Worksheet Functions | |||
Having trouble printing selected sheets in Excel | Excel Discussion (Misc queries) | |||
Should be able to name Excel sheets based on cells in workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |