Printing Spreadsheets Duplex on Your Xerox Printer

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.

  1. excel - CopyOpen your workbook.
    Follow the following instructions based upon In Microsoft Excel 2003 and prior
  2. On the File menu
  3. Point to Print, and then click Properties.
    In Microsoft Office Excel 2007 and Excel 2010
  4. Click the Microsoft Office Button/File, point to Print, click Print, and then click Properties.
  5. On the Layout tab, select one of the duplex options, and then click OK.
  6. Click OK in the Print dialog box.
  7. 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.

Related Posts

Receive Updates

3 Comments

  1. Ruben van Thiel May 26, 2015 - Reply

    Another thing you can do is the following.

    Option 1:
    – Select all tabs in Excel(right click on the tab of the Current Sheet>Select all sheets)
    – Go to the Excel ribbon>Page Layout
    – Click on the arrow that points down in the right corner in Page Setup
    – In the Page Setup, navigate to the tab Sheet
    – Click on Options
    – Set your driver preferences(simplex/duplex/stapling/etc.)

    Option 2:

    – Open Excel
    – Go to File> Print
    – Go to Printer Properties
    – Set your driver preferences(simplex/duplex/stapling/etc.)
    – In the Driver Preferences, click on the Arrow and save it as a new template
    (if you save it as Microsoft Office Excel defaults, these driver preferences will be loaded everytime you open a new excel sheet).

    • Cheryl Otstott May 26, 2015 - Reply

      Hi Ruben,
      Thank you for reading the At Your Service blog. I appreciate the additional information. I am sure many will find your step useful and I thank you for taking the time to add them here.
      Thanks,
      CherylO-Xerox

  2. […] week we spoke about printing duplex or double sided spreadsheets from Microsoft Excel. Today let’s talk about a couple of other printing issues you might see with Microsoft Excel and […]

Post A Comment

Your email address will not be published. Required fields are marked *

To see how we protect your personal data, view our Privacy Policy.