Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Remove the Dotted Borders in Excel

Date:2019-7-17 Author:Cordelia

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.

How to Remove the Dotted Borders in Excel

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.

How to Remove the Dotted Borders in Excel

How to Remove the Dotted Borders in Excel

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

How to Remove the Dotted Borders in Excel

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.

How to Remove the Dotted Borders in Excel

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

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

2 thoughts on “How to Remove the Dotted Borders in Excel”

  1. mobile legends hack says:

    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!

    1. Olivia says:

      nice to have readers like you:)

Leave a Reply

Your email address will not be published. Required fields are marked *