Microsoft KB Archive/264500

= XL97: Page Setup in Print Preview Does Not Apply to All Grouped Sheets =

Article ID: 264500

Article Last Modified on 9/7/2001

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q264500





SYMPTOMS
If you make changes to the settings in the Page Setup dialog box when you have multiple worksheets grouped, Microsoft Excel may apply your changes to the active worksheet only.



CAUSE
This behavior occurs when the following conditions are true:
 * You have multiple worksheets grouped.

-and-
 * You access the Page Setup dialog box by clicking Setup from within print preview.

When you click Setup in print preview, Microsoft Excel only applies the Page Setup dialog box settings to the actively previewed sheet.



WORKAROUND
To change settings for all grouped worksheets at once, click Page Setup on the File menu, rather than from within print preview.

Additional query words: XL97

Keywords: kbprint kbprb KB264500

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.