Printing Multiple Worksheets In Excel Double-Sided. Click on the properties button (excel 2007) or printer properties link (excel 2010 or a later version). Look through the tabs in the dialog box to locate the controls for duplexing.
Repeat these steps for every sheet in the workbook. I have been working with canon enterprise support with this, and they believe this issue to be with microsoft. When i print, i would generally click, print entire workbook which then takes my document from 3 pages to 4.
Hold The Control Key And Press The P Key (Or Command + P If You’re Using A Mac) In The Print Window That Opens, Under The Settings Option, Select Print Active Sheets.
Here is how to get multiple worksheets in one workbook printed with true double sided printing (to prevent each worksheet from starting a new page): Ensuring duplex print is set, selecting the required tabs, select print active sheets then, and this is the odd bit, select page setup then options click ok then ok again, which seems like you haven't really done anything, then print. Each sheet is multiple pages.
This Dialog Box Is Created By Your Printer Driver, So It's Tough To Give Any Further Instructions After That.
In microsoft office excel 2007 and excel 2010. Click on the properties button (excel 2007) or printer properties link (excel 2010 or a later version). Pages one and two print double sided no problem, but.
* Open Each Worksheet That You Are Going To.
Then you can print all of them together in one print job. Look through the tabs in the dialog box to locate the controls for duplexing. This also works in vba by using an array as parameter to the sheets collection:
Microsoft Word Is Not Having The Same Problem, Even With Long Documents On Word It.
You need to go to each tab and set the printing properties. To save paper, i prefer to print double sided whenever possible. On the layout tab, select the one of the duplex options, and then click ok.
I Have An Excel 2007 Workbook With Many Sheets (32).
Only the first worksheet is printed duplex in excel. This is something messed up in excel itself. Select ok, apply, and then ok again.