Print preview-hide dotted lines.

[lunker55]

After I do a print preview and go back to normal view, the dotted lines show
the page layout over my spreadsheet. How do I hide them without changing the
print area?
They are annoying!
joe

 

[JulieD]

Hi Joe

Try Tools / Options - View tab and unclick Page Breaks

Hope this helps

Cheers
JulieD

 

[JE McGimpsey]

Since I occasionally like to see page breaks in Normal view, I have this
macro attached to a custom toolbar button:

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

 

[lunker55]

Thanks Julie

Joe

Hi Joe

Try Tools / Options - View tab and unclick Page Breaks

Hope this helps

Cheers
JulieD