Microsoft KB Archive/100361

{| = Excel: Page Breaks Not Displayed Correctly with Fit To Option =
 * width="100%"|

Last reviewed: September 12, 1996

Article ID: Q100361 The information in this article applies to:
 * Microsoft Excel for Windows, versions 4.0, 4.0a

SUMMARY
In Microsoft Excel version 4.0, when you use the Fit To N Pages Wide By N Tall option, you may experience the following problems:


 * Automatic page breaks will not be displayed.
 * If you repaginate the sheet using the Reduce/Enlarge To option and select the Fit To N Pages Wide By N Tall option, page breaks will be displayed but they will not appear where you expect them to.
 * If you clear and reselect the Automatic Page Breaks check box in the Display Options dialog box (from the Options menu, choose Display), page breaks will not be displayed until the sheet is repaginated.

Workaround
To work around this problem, do the following:


 * 1) From the File menu, choose Page Setup. Under scaling, select the Reduce/Enlarge To option. Page Breaks now appear on the worksheet, but they are displayed as if the Reduce/Enlarge To option was set to 100.
 * 2) Under Scaling, select the desired page size in the Fit To N Pages Wide By N Pages Tall option.
 * 3) From the File menu, choose Print Preview.
 * 4) Choose the Close button to close print preview.

The page breaks should now be correctly displayed for the chosen scale.
 * }