Microsoft KB Archive/815356

= Excel may not automatically fit the worksheet to the page after you set the &quot;Fit to&quot; option =

Article ID: 815356

Article Last Modified on 1/30/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



SUMMARY
Microsoft Excel 2000 and later versions of Excel may not automatically fit the worksheet to the page as earlier versions of Excel did.

This issue occurs when you click Page Setup on the File menu, click to select the Fit to check box on the Page tab, and then type the number of pages wide that you want the worksheet to fit. For example, you type 1.



MORE INFORMATION
In earlier versions of Excel, when you click to select the Fit to check box and then specify a setting in either the page(s) wide by or the tall boxes, Excel would clear the manual page breaks both vertically and horizontally to automatically make the worksheet fit the page wide by the page tall.

However, in Excel 2000 and in later versions of Excel, the Fit to option does not automatically clear all the manual page breaks in a worksheet. Excel clears the manual page breaks for only the width or height that you specify. For example:
 * When you specify a page width setting in the page(s) wide by box, Excel clears all the manual vertical page breaks in the worksheet.
 * When you specify a page height in the tall box, Excel clears all the manual horizontal page breaks in the worksheet.
 * When you do not specify either a width or height by clearing both the page(s) wide by box and the tall box, Excel retains both the vertical and horizontal manual page breaks in the worksheet.

This is a design change in Excel 2000 and in later versions of Excel. This change gives you more flexibility when you fit a worksheet to a page.

Additional query words: XL2000 XL2002 XL2003 XL2007

Keywords: kbexpertisebeginner kbbug kbprb KB815356

-

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

© Microsoft Corporation. All rights reserved.