Microsoft KB Archive/169033: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 106: Line 106:


</div>
</div>
and then double-click the selected text to go to the &quot;Print the active sheets, a selected range, or an entire workbook&quot; topic.
and then double-click the selected text to go to the "Print the active sheets, a selected range, or an entire workbook" topic.


</div>
</div>

Latest revision as of 10:04, 21 July 2020

Knowledge Base


Article ID: 169033

Article Last Modified on 9/20/2007



APPLIES TO

  • 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



This article was previously published under Q169033


SYMPTOMS

When you print more than one worksheet in a workbook, only the first worksheet is printed duplex.

CAUSE

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.

RESOLUTION

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.

  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 the Duplexing option.

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.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


REFERENCES

For more information about printing workbooks, click the Index tab in Microsoft Excel 97 Help, type the following text

printing, workbooks


and then double-click the selected text to go to the "Print the active sheets, a selected range, or an entire workbook" topic.


Additional query words: XL97 XL

Keywords: kbbug kbprint KB169033