Excel: Displaying Automatic Page Breaks

 Last reviewed: August 20, 1995
Article ID: Q92364

The information in this article applies to:

  • Microsoft Excel for Windows, versions 2.x, 3.x, 4.x, 5.0, 5.0c
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel for the Macintosh, versions 2.x, 3.x, 4.x, 5.0

SUMMARY

To display automatic page breaks in Microsoft Excel, follow the appropriate procedure below.

Microsoft Excel Version 5.0 and later

  1. From the Tools menu, choose Options.

  2. Select the View tab.

  3. In the Window Options box, select the Automatic Page Breaks option. Choose OK to accept the change.

Microsoft Excel Versions 3.0, 4.0

  1. From the Options menu, choose Display.

  2. In the Display Options dialog box, select the Automatic Page Breaks check box.

NOTE: Because the Automatic Page Breaks option is not saved with your document, the next time you open your worksheet you will need to reselect this option to display automatic page breaks.

Microsoft Excel Version 2.0 and later

  1. From the File menu, choose Page Setup.

  2. In the Page Setup dialog box, choose the OK button. 

        -or-

  3. From the File menu, choose Print.

  4. In the Print dialog box, select the Print Preview check box.

  5. Choose the OK button.

NOTE: To avoid printing your document, choose the Cancel button in Print Preview.

MORE INFORMATION

When you print a worksheet, Microsoft Excel divides it into pages based on print area, paper size, orientation, font size, and margin settings. The page divisions are marked by automatic page breaks, indicated by dashed lines in your worksheet. Automatic page break marks are displayed after you use Page Setup, Print Preview, or after you select the Display option.

In Microsoft Excel versions 4.0 and 5.0, if the Fit to Pages scaling option is turned on, no page breaks (either automatic or manual) will ever be displayed or used. To display page breaks, you must turn off the Fit to Pages option.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, Pages 530-537

"Microsoft Excel User's Guide," version 3.0, Pages 536-539

KBCategory: kbother
KBSubcategory:

Additional reference words: 7.00 2.00 2.01 2.10 2.20 2.21 3.00 4.00 5.0
5.00 view save show

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 20, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.