Remove page break

run this in a module.

Sub test()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets

ws.Cells.PageBreak = xlPageBreakNone

Next ws
End Sub

Select allOpen in new window

or if you want it automatic , when everytime excel opens then

Private Sub Workbook_Open()

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets

ws.Cells.PageBreak = xlPageBreakNone

Next ws


End Sub

Select allOpen in new window

If you put the file into Page Break Preview mode, the fixed page breaks will be a solid line and the variable breaks based on page size and print settings will be hashed lines.