Microsoft KB Archive/214109

= XL2000: Manual Page Breaks Ignored with "Fit to Page" Options =

Article ID: 214109

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214109





SYMPTOMS
In Microsoft Excel, when you set a document to Fit to  page(s) wide by   tall in the Page Setup dialog box, manual page breaks do not appear on the worksheet and are ignored in Print Preview and in the printed output.

NOTE: It is possible to clear the tall box to preserve manual horizontal page breaks or clear the wide box to preserve manual vertical page breaks.



MORE INFORMATION
To emulate the process of scaling a document to fit a certain number of pages and to position page breaks at specific rows or columns, use the Adjust to option. To do this, follow these steps:
 * 1) On the File menu, click Page Setup, and then click the Page tab.
 * 2) Under Scaling, click Fit to, and then specify the number of pages wide by the number of pages tall.
 * 3) On the File menu, click Print Preview.

This forces the document to be scaled according to the Fit to setting.
 * 1) Click Close.
 * 2) On the File menu, click Page Setup again. This time, select the Adjust to option under Scaling.

Note the percentage figure that is displayed. This figure represents the percentage of the standard size that the document is scaled to in print preview when the Adjust to option is selected.
 * 1) Click OK.

Additional query words: show page break XL2000

Keywords: kbprb kbprint KB214109

-

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

© Microsoft Corporation. All rights reserved.