Why do i see dotted lines in excel

In this tutorial, I will show you the possible reasons why these dotted lines appear and how to remove these dotted lines. Your worksheet can have any one or more of these settings and you can easily remove these lines and disable it.

This is one of the most irritating things for me in Excel. Sometimes, I see these page-breaks dotted lines as shown below that just refuse to go away. Now, I understand the utility and purpose of keeping these. It divides your worksheet into sections and you would know what part will be printed on one page and what will spill over. A super easy but not ideal fix of this is to close the workbook and open again.

Reopening a workbook will remove the page break dotted lines. Note that the above steps would stop showing the dotted lines only for the workbook in which you have unchecked this option. For other workbooks, you will have to repeat the same process if you want to get rid of the dotted lines. What's new New posts New Excel articles Latest activity. New posts. Excel Articles Latest reviews Search Excel articles. Log in Register. Search titles only. Search Advanced search…. Search forums.

Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled.

For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Remove annoying dashed lines from Excel sheet.

Thread starter billiboy Start date Jun 9, Joined Jul 16, Messages Uncheck it. Strange dotted lines might also be due to a page break. In newer versions of Excel, the manually-added page breaks are presented as solid lines, whereas automatic page breaks are displayed as dotted lines. To remove these dotted lines, select a cell in a row that immediately follows the primary page break. Click here and select Remove Page Break. This is how you remove the solid horizontal lines in Normal View.

However, the dotted lines that are generated automatically will still be there. Remove them by selecting the File tab at the top of the screen. Then, navigate to Options , located in the menu on the left. Click Advanced and scroll down to Display options for this worksheet.