XL2000: Manual Page Breaks Ignored with "Fit to Page" Options (214109)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q214109

SYMPTOMS

In Microsoft Excel, when you set a document to Fit to x page(s) wide by x 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.
  4. Click Close.
  5. 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.
  6. Click OK.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbprb kbprint KB214109
©2003 Microsoft Corporation. All rights reserved.