Only the first worksheet is printed duplex in Excel (214383)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 2002
  • Microsoft Office Excel 2003
This article was previously published under Q214383

SYMPTOMS

In Microsoft Excel, when you print more than one worksheet in a workbook, only the first worksheet is printed duplex (on both sides of a sheet of paper).

CAUSE

If you turn on the duplex option in the Printer Properties dialog box while the workbook that you are printing is currently open, the duplex option is applied only to the active worksheet.

WORKAROUND

To apply the duplex option to all worksheets in your workbook, follow these steps:

NOTE: The following steps were performed with a Hewlett Packard (HP) LaserJet 4si MX set as the default printer.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
  1. Open your workbook.
  2. On the File menu, point to Print, and then click Properties.
  3. On the Layout tab, select the one of the duplex options, and then click OK.
  4. Click OK in the Print dialog box.
  5. Repeat these steps for every sheet in the workbook.
When you print your workbook, all worksheets are printed with the duplex option.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about printing workbooks, click Microsoft Excel Help on the Help menu, type print the active sheets in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:7/18/2006
Keywords:kbbug kbpending kbprint KB214383
©2004 Microsoft Corporation. All rights reserved.