X

How to Remove the Dotted Borders in Excel

Have you ever seen one or more dotted borders in your Excel worksheet? It appears all of a sudden and can’t be deleted by normal means, which could be quite annoying.

This kind of dotted line is actually caused by the switching of workbooks views. You can see this feature in View tab or the bottom right of Excel window. When you switch the view from Normal to other styles then switch back, you are very likely to see several dotted lines in the page.

To remove these dotted lines, just select Print Area in Page Layout tab. Then click Clear Print Area.

If the dotted lines still exist, click FileOptionsAdvanced. Scroll down to find the section of Display options for this worksheet (the sheet name should be in accordance with the one you are editing). Then uncheck Show page breaks.

Hit OK to go back to the sheet page, all the dotted lines should have gone.

Categories: Excel Tips
Cordelia:

View Comments (2)

  • Hey there! I could have sworn I've been to this blog before
    but after checking through some of the post I realized it's new to me.
    Anyhow, I'm definitely glad I found it and I'll be book-marking and checking back frequently!