<div>
I have a Workbook here where 2 sheets get printed double sided and 4 sheets get printed single sided. Excel saves the printing settings with the workbook and the HP Printer respects the settings. <br />
<br />
Did you try saving the print settings? <br />
<br />
Then some printers override this. I have this situation with a client workbook and a Xerox Printer. <br />
<br />
You may just have to set each time.
</div>


I have a Workbook here where 2 sheets get printed double sided and 4 sheets get printed single sided. Excel saves the printing settings with the workbook and the HP Printer respects the settings.

Did you try saving the print settings?

Then some printers override this. I have this situation with a client workbook and a Xerox Printer.

You may just have to set each time.

agwalsh

<div>
Thank you both so much for this - sometimes people thinks this stuff is an Excel problem - when often it's a printer problem!
</div>


Thank you both so much for this - sometimes people thinks this stuff is an Excel problem - when often it's a printer problem!

<div>
<div class="content wysiwyg-content">
I have a user who needs to print out the contents of 30 worksheets one sided. She is using an Olivetti d-Color MF222 &nbsp;which prints out duplex by default. Even though she changes the setting to one-sided it defaults back to duplex. Any idea on how she can set up &nbsp;the printer to just print one sided?
</div>
</div>


I have a user who needs to print out the contents of 30 worksheets one sided. She is using an Olivetti d-Color MF222  which prints out duplex by default. Even though she changes the setting to one-sided it defaults back to duplex. Any idea on how she can set up  the printer to just print one sided?

Setting up a printer to print Excel worksheets  one sided rather than the default duplex.

A printer is a peripheral which makes a persistent human readable representation of graphics or text on paper or similar physical media. Traditional printers are being used more for special purposes, like printing photographs or artwork, and are no longer a must-have peripheral; 3D printing has become an area of intense interest, allowing the creation of physical objects. An image scanner is a device that optically scans images, printed text, handwriting, or an object, and converts it to a digital image. Hand-held scanners, where the device is moved by hand, have evolved from text scanning "wands" to 3D scanners used for industrial design, reverse engineering, test and measurement, orthotics, gaming and other applications.

Printers and Scanners

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.