Using "Fit To" Option Does Not Increase Scale to Fill Page
Article ID: 142590
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q142590
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
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
In Page Setup, select 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: 5.00a 5.00c 8.00 97 XL97 98 XL98 XL
Keywords: kbprint kbprb KB142590