Page Breaks

[Guest]

Excel has inserted visible page breaks (dashed lines) in the normal view and page break view on my spreadsheet. I did not set a print area and when I try to clear it the lines remain. How can I get rid of these lines? Thank you for your help

 

[JE McGimpsey]

Tools/options/View, then uncheck the Page breaks checkbox.

If you want to do this a lot, attach this to a toolbar button or
keyboard shortcut:

Public Sub TogglePageBreaks()
With ActiveSheet
.DisplayPageBreaks = Not .DisplayPageBreaks
End With
End Sub