Microsoft KB Archive/92364

{|
 * width="100%"|

Excel: Displaying Automatic Page Breaks

 * }

-

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, 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-
 * 1) From the File menu, choose Print.
 * 2) In the Print dialog box, select the Print Preview check box.
 * 3) 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.