XL: "Fit To" in Page Setup Does Not Fit to Page As Earlier Versions of Excel (815356)

SUMMARY

When you click Fit to in Page Setup on the File menu, and then type the number of pages wide that you want the worksheet to fit (for example type 1), Microsoft Excel 2000 or Excel 2002 may not automatically fit the worksheet to the page as earlier versions of Excel did.

MORE INFORMATION

In earlier versions of Excel, when you click the Fit to option, 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 later, 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 later to give you more flexibility when you fit a worksheet to a page.

REFERENCES

For more information about about how to print a worksheet to fit a paper width or a number of pages, click Microsoft Excel Help on the Help menu, type fit to page in the Office Assistant or the Answer Wizard, and then click Search to view the topic.