Controlling Display of Page Breaks

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 Breaks tool on the Page Layout tab of the ribbon. 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. Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and Excel 2013 display the File tab of the ribbon and then click Options.)
  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. (See Figure 1.)
  4. Figure 1. The advanced options of the Excel Options dialog box.

  5. Using the drop-down list at the top of the section, indicate which worksheet you want to affect.
  6. Set the Show Page Breaks check box as desired. If selected, then Excel displays page breaks on-screen for the designated worksheet.
  7. Click OK.