Displaying Page Breaks in a Worksheet

There are two types of page breaks that can appear in an Excel worksheet: manual or automatic. You insert page breaks manually by using the Page Layout tab of the Ribbon. Just click the Breaks tool, in the Page Setup group, and you'll see a drop-down list of breaks you can insert. Automatic page breaks are those that are calculated by Excel based on various settings, such as page size, margins, cell size, and the like.

Excel allows you to control whether page breaks are displayed on-screen (as dashed lines) by following these steps:

1. Click the Office button and click Excel Options. Excel displays the Excel Options dialog box.
2. Click the Advanced option at the left of the dialog box.
3. Scroll through the available options until you find the Display Options for this Worksheet section. (Click here to see a related figure.)
4. Using the drop-down list at the top of the section, indicate which worksheet you want to affect.
5. Set the Show Page Breaks check box as desired. If selected, then Excel displays page breaks on-screen for the designated worksheet.
6. Click OK.