You are currently offline, waiting for your internet to reconnect

Your browser is out-of-date

You need to update your browser to use the site.

Update to the latest version of Internet Explorer

Only first worksheet prints duplexed

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q169033
SYMPTOMS
When you print more than one worksheet in a workbook, only the firstworksheet is printed duplex.
CAUSE
If you turn on the duplex option in the Printer Properties dialog boxwhile the workbook you are printing is currently open, the duplex optionwill only be applied to the active worksheet.
RESOLUTION
To have the duplex option apply to all worksheets in your workbook, do thefollowing:

NOTE: The following steps were performed with an HP LaserJet 4si MX set asthe default printer.

  1. Open your workbook.
  2. On the File menu, point to Print, and then click Properties.
  3. On the Paper tab, click More Options.
  4. In the Paper - More Options dialog box, select the one of the duplexing options, and then click OK.
  5. Click OK in the Printer Properties dialog box.
  6. Repeat this for every sheet in the workbook.
When you print your workbook, all worksheets will be printed with theDuplexing option.

NOTE: Microsoft realizes that having to set the print propertiesindividually on each sheet is very inconvenient for large files, and isconsidering a fix for a future version.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft productslisted at the beginning of this article.

REFERENCES
For more information about printing workbooks, click the Index tab inMicrosoft Excel 97 Help, type the following text
printing, workbooks
and then double-click the selected text to go to the "Print the activesheets, a selected range, or an entire workbook" topic.
XL97 XL
Properties

Article ID: 169033 - Last Review: 09/20/2007 20:18:00 - Revision: 2.0

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007
  • kbbug kbprint KB169033
Feedback