How to remove Print Preview lines in Excel 2007

Written by paul travers Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to remove Print Preview lines in Excel 2007
Preview page break lines can sometimes remain when you return to normal view. (Stockbyte/Stockbyte/Getty Images)

When you take a Microsoft Excel worksheet into "Print Preview" mode to see how it will look when you print it, you will see a number of lines representing page breaks. Dotted lines denote automatic page breaks inserted by Excel and unbroken lines show page breaks that you have inserted manually. When you return to "Normal" mode to continue working, you may still see these lines as the "Show Page Breaks" option will have turned on automatically. You can remove the preview lines by changing the display settings.

Skill level:


  1. 1

    Click the "View" tab, then click "Normal" in the "Workbook Views" section. You can also click the "Normal" button on the status bar. This looks like a grid of blank worksheet cells.

  2. 2

    Click the Microsoft Office button. This is the button that shows the Microsoft logo. Click "Excel Options," then click the "Advanced" tab.

  3. 3

    Scroll down to the "Display options for this worksheet" section. Click to clear the "Show Page Breaks" tick-box. The print preview lines will be removed.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.