Cannot remove a page break

Each month, I update my worksheet with data for that month. When it comes to printing it out, I hide the previous month’s data by hiding the unwanted rows. Usually, the data is printed out one sheet. This month however there are more data rows which means I would like to print it out on two sheets. I have been trying to do this using a page break half way down the rows at a convenient point.

What I have ended up with is a page break near the top of my sheet, which I cannot remove. I had several on the sheet, which I discovered, using view page breaks, could be dragged to the edge of the document. This I did successfully. However, one remains, which I cannot drag off as I did with the others.

I am in need of rescuing from this predicament. Please make it simple!

Click on a cell below the page break.
Go to the menu: Click on Sheet > Delete Page Breaks > Row Break.

Tried that. Unfortunately, Delete Page Breaks is greyed out

Is there a dotted blue line on the row?

@Tyndale ,
Try View → Page Break

In normal view, there is a dotted blue line.

The issue (I think!) is related to the fact that the very top row of my worksheet contains header information which is common to all months, so that row is frozen. As I scroll down, it remains at the top of the screen. If I unfreeze it, the sheet is split into two pages, but not as I want. I get the header as page1 and the rest of it on page 2

On a copy, have you tried Unfreeze > Delete Page Breaks > Freeze?

with it unfrozen, the delete page breaks is greyed out

After a lot of clicking around, I seem to have fixed it. Something to do with the scaling slider which changes page breaks for large worksheets.

Thanks all for your help

1 Like