XL97: Page Setup in Print Preview Does Not Apply to All Grouped Sheets (264500)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
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.
Modification Type:MajorLast Reviewed:9/7/2001
Keywords:kbprb kbprint KB264500
©2002 Microsoft Corporation. All rights reserved.