Printing Spreadsheets Duplex on Your Xerox Printer

kharraid
Jun 17, 2015
1 min read

We have seen questions about printing spreadsheets. The questions are mostly about how to print using finishing options, such as duplex, with a spreadsheet. Let’s take a look at how to setup a spreadsheet using Microsoft Excel as our example. The process may be different depending on the spreadsheet program you are using.

Put simply each worksheet must have the finisher option applied to it separately. It is not as easy as maybe it should be but it is a known issue within Excel 2003, 2007, and 2010.

Please visit http://support.microsoft.com/kb/214383 for more information directly from Microsoft. The solution or workaround is as follows according to the Microsoft support site.

To apply the Finishing options such as duplex, or stapling to all worksheets in your workbook, follow these steps:

When you print your workbook, all worksheets are printed with the finishing options selected.

Open your workbook.Follow the following instructions based upon In Microsoft Excel 2003 and prior
On the File menu
Point to Print, and then click Properties.In Microsoft Office Excel 2007 and Excel 2010
Click the Microsoft Office Button/File, point to Print, click Print, and then click Properties.
On the Layout tab, select one of the duplex options, and then click OK.
Click OK in the Print dialog box.
Repeat these steps for every sheet in the workbook.