Microsoft KB Archive/214257

= XL2000: Using "Fit To" Option Does Not Increase Scale to Fill Page =

Article ID: 214257

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214257





SYMPTOMS
In the Page Setup dialog box, if the specified print area is less than one page, and if you select the Fit To option, the page is printed at 100-percent scale. In other words, Microsoft Excel does not adjust the scale of a print range greater than 100 percent to fill an entire page.



WORKAROUND
To fill an entire page with a specified print area that is smaller than a single printed page, use either of the following methods.

Method 1
On the File menu, click Page Setup. In the Page Setup dialog box, click Adjust To, and select a scale that is greater than 100 percent. This method does not insure that the print range stays on one page, however.

Method 2
On the File menu, click Page Setup. In the Page Setup dialog box, click Fit To, and then manually size the rows and columns within the print range to fill the page. (You can view the sheet in print preview to see if the print range fills the page).

Additional query words: xl2000

Keywords: kbprint kbprb KB214257

-

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

© Microsoft Corporation. All rights reserved.