The above steps would stop showing the page break dotted line for the workbook.
In the Excel Options dialog box that opens, click on the Advanced option in the left pane.Here is a better way to remove these dotted lines: Reopening a workbook will remove the page break dotted lines. It divides your worksheet into sections and you would know what part will be printed on one page and what will spill over.Ī super easy (but not ideal) fix of this is to close the workbook and open again. 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.
HOW TO INSERT PAGE BREAKS ACROSS SHEETS IN EXCEL HOW TO
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)
0 kommentar(er)
