Article ID: 169033 - View products that this article applies to.
This article was previously published under Q169033
When you print more than one worksheet in a workbook, only the first worksheet is printed duplex.
If you turn on the duplex option in the Printer Properties dialog box while the workbook you are printing is currently open, the duplex option will only be applied to the active worksheet.
To have the duplex option apply to all worksheets in your workbook, do the following:
NOTE: The following steps were performed with an HP LaserJet 4si MX set as the default printer.
NOTE: Microsoft realizes that having to set the print properties individually on each sheet is very inconvenient for large files, and is considering a fix for a future version.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
For more information about printing workbooks, click the Index tab in Microsoft Excel 97 Help, type the following text
printing, workbooksand then double-click the selected text to go to the "Print the active sheets, a selected range, or an entire workbook" topic.
Article ID: 169033 - Last Review: September 20, 2007 - Revision: 2.0
Contact us for more help
Connect with Answer Desk for expert help.