Article ID: Q131165
The information in this article applies to:
In Microsoft Excel, when you print multiple worksheets, either by selecting individual sheets, or by printing the entire workbook, the Layout option for individual sheets may be ignored. For example, if one of the worksheets is formatted to print in the "1 up" Layout option, it may be printed with the "4 up" Layout option instead.
This behavior occurs because the Layout option, available when you print to a PostScript printer, applies to the entire print job. Therefore, when you print multiple worksheets at one time, or when you print one print job, each of the sheets is printed with the Layout option that is applied to the first selected sheet. For example, if you print Sheet1 and Sheet2 by clicking the Sheet1 sheet tab, pressing the CTRL key, and selecting the Sheet2 sheet tab, when you print using the Selected Worksheet(s) print option, the worksheets are printed using the Layout option applied to Sheet1.
To print multiple worksheets that have different Layout options, print each sheet individually by selecting one worksheet at a time and then clicking Print on the File menu or the Print button on the Standard toolbar.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
The Layout option specifies how many pages of your document will be printed on one piece of paper. For example, "1 up" prints one page of your document per piece of paper, "2 up" prints two pages on one piece of paper, dividing the paper in half.
Note that other printing options such as orientation, scaling, and paper size are applied individually to each worksheet, even when you print selected worksheets or the entire workbook. For example, if you print a workbook that contains a worksheet in portrait orientation and a worksheet in landscape orientation, the worksheets are printed in the expected orientation.
For more information about setting up a worksheet for printing in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text
printing, pdouble-click the selected text, and then double-click Setting Up A Worksheet For Printing to go to the "Setting Up A Worksheet For Printing" topic.
Additional query words: 7.00 8.00 97
Keywords : xlprint xlwin Version : WINDOWS:7.0,97 Platform : WINDOWS
|
Last Reviewed: May 12, 1999 © 1999 Microsoft Corporation. All rights reserved. Terms of Use. |