Viewing page breaks is useful when using Excel. However, when you switch back to Normal view from a page break view, the page breaks will be visible as black dotted lines.  This can be really annoying.

To hide page breaks:

Excel 2007

  1. Click on the Office button in the top left corner.
  2. Select the Excel Options button at the bottom right side of the Office menu.
  3. Select Advanced in the left column.
  4. Scroll down to the Display Options for this Worksheet section.
  5. Uncheck the box marked Show Page Breaks.
  6. Click OK.

Excel 2003

  1. Go to the Tools menu and select Options.
  2. Select the View tab.
  3. In the Window Options section, uncheck the box marked Page Breaks.
  4. Click OK.