Print on both sides (duplex printing) by default in Excel 2010

Question

Every time when I create new a document and Print using Ctrl + P, it sets the default to Print on one side.

• How can I change this option to Print on both sides by default?
• Also, if possible: how can I change this option to every user in my domain to automatically print on both sides when they print using excel?

Answer 1

If you open excel, winword or an other program and change the settings from that instance then you are only changing them for that session. After closing the program the new settings will be lost.

To keep setting permanently go via the control panel to the printer settings. There you can do two things:

1. If you always want to print in duplex (not just via excel) then you can change this setting here. The new settings will be the default for all programs.
2. If you only wabt this for a single or a few programs and changing it is too much work, you can create a profile via printer settings. This might vary per printer.

Answer 2

I don't know if you can save this setting in Excel, but you can create a printing shortcut in Windows and use that when you print from Excel. Go to Start -> Settings -> Printers and Faxes, then right-click on your printer and select Printing Preferences... from the menu. You'll see a Printing Shortcuts tab that allows you to save a collection of print settings that you can select from Excel (or any other application).

Answer 3

For Excel 2016, it will remember the print settings on a per sheet basis.

To prove this:

• Create a new Excel spreadsheet with two sheets.
• Go to print one sheet and choose "Print on both sides" (you don't have to actually print it)
• Save the spreadsheet.
• Close Excel
• Open the spreadsheet again and select either tab and try to print. One will still be duplex and one will not be.

Personally, I don't like this, but I guess it's there for a reason.