Now, I understand the utility and purpose of keeping these. Sometimes, I see these page-breaks dotted lines (as shown below) that just refuse to go away. This is one of the most irritating things for me in Excel. Let’s dive in and see how to remove these dotted lines in Excel in each scenario.
Your worksheet can have any one or more of these settings and you can easily remove these lines and disable it. These are not really dotted lines (rather faint solid lines that looks like dotted borders around the cells) Gridlines that appear in the whole worksheet.Borders that have been set to show as dotted lines.Due to Page breaks where Excel visually show page breaks as dotted lines.
There can be various reasons for the dotted lines to appear in Excel: Possible Reasons for Dotted Lines in Excel
