page breaks

B

Bacchus

Can someone tell me how to get rid of the page breaks on my worksheets. I
find them to be distracting, espeically when I do not need them there at
all.

thanks
 
J

JE McGimpsey

Personally, I put a button on my working toolbar attached to this macro:

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


But you can also hide them by choosing Tools/Options/View and uncheck
the Page breaks checkbox.

If you don't care about printing the sheet, another alternative is to
choose File/Page Setup and click the "Set to 1 page(s) wide by 1 tall"
radio button.
 
B

Bacchus

thanks that did it.



JE McGimpsey said:
Personally, I put a button on my working toolbar attached to this macro:

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


But you can also hide them by choosing Tools/Options/View and uncheck
the Page breaks checkbox.

If you don't care about printing the sheet, another alternative is to
choose File/Page Setup and click the "Set to 1 page(s) wide by 1 tall"
radio button.
Click to expand...
 
Top