Page Breaks

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top