How to Get Rid of Dashed / Dotted Print Area Lines in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on January 1, 2023

This tutorial demonstrates how to remove dashed print area lines in Excel.


remove page break lines


Remove Dashed Print Area Lines

Once you’ve used Page Break Preview in Excel (View > Page Break Preview) to view and set page breaks, you’ll see dashed lines separating pages for printing, even when you go back to the normal view.

Say you have the table below with page breaks as displayed.


page breaks view initial


As you can see, there are page break lines between Columns G and H, and Rows 25 and 26. If you want to disable this in Normal view and remove dashed print area lines, follow these steps:

  1. First, go to the File tab, and click on Options at the bottom of the left-side menu.


excel options set 2


  1. In the Options menu, go to Advanced, scroll down to Display options for this worksheet, uncheck Show page breaks, and click OK.


excel options show page breaks


Page-break lines are no longer showing in the normal view.


page breaks view final


You must ensure that, before going to Excel Options, you’re in Normal view. Check the View tab in the Ribbon and confirm that Normal is selected.


break lines normal view

AI Formula Generator

Try for Free

See all How-To Articles