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

Argggh…Its come back to bite me!

Please see my first post which explains my predicament. In summary, when I hide my previous months entries, a blue dotted line appears which acts as a page break. The result being my print preview shows 2 pages - the first being the page header, the second being all my data. I want it all to print on one page, and adjusting the scaling slider doesn’t help like it did last time.

I have spent hours trying to get out of this, and am stuck - I need some help please.

In order for us to evaluate the bite force, please upload your file.

PageBreak.xls (503.5 KB)

I have deleted some personal data, but the formatting remains the same
ps I am trying to print out Aprils figures

The file format is .xls and in Excel the file is printed with the same page breaks.

Diagnosis. The file has a manual page break before the hidden row 189.

Treatment.

  1. Open rows 3-242
  2. Remove the manual page break before row 189.
  3. Hide rows 3-242.
1 Like

thanks sokol92
At your step2 to remove the page break, I went to view - page break and slid the blue line up to the top of the file. Was this what you meant?

It all seems to work fine on the edited file I posted. On the original file it looks good in print preview, but at the bottom of the screen it shows page 3/4 so there are other print breaks active. Thanks for your help today. After a break, I managed to delete some more page breaks, so the whole month plus header prints out on one page.

Just one question: what is the distinction of the blue dotted line as opposed to other black dotted lines?

Not quite so.

  1. Menu / View / Page Break
  2. Select cell A189. The horizontal blue line means that there is a manual page break before the row.
  3. In the context menu (right mouse button), select “Delete Page Breaks” (there is no such menu item for automatic page breaks).

The same menu item can also be used to remove all manual page breaks from a range of cells.

Thanks sokol92
I have made some notes of this in case it bites me again! :grinning:

1 Like