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.
The other finishing options. for instance stapling, would be set up in a similar fashion.
Please search the online support for your machine to find further or more detailed instructions by either searching on spreadsheet or the finishing option such as stapling or duplex.