page breaks

  • Thread starter Thread starter Bacchus
  • Start date Start date
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
 
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.
 
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...
 
Back
Top