How can I remove manually added page breaks?

Question

I added a page-break to my spreadsheet but now I want some more lines at the top of page 2. I want to remove the page break as part of doing this.

How do I remove the existing page break (that I had added before)?

I've gone through all the menus and options and I can't find a thing. I've tried adding the new lines for page 2 in several places but they keep falling into page 1. I want new lines at line 22 but on page 2.

Screenshot showing pagebreak I am trying to remove (blue line):

page-break I am trying to remove

score 3 · Accepted Answer · edited Mar 13 '16 at 13:38

3

Go to

[Edit],[Delete Page Break]

This is the 5th item from the bottom

Note from Michael: You need to be on the FIRST row of page 2 for the 'delete page break - row' to NOT be grayed out!

enter image description here

edited Mar 13 '16 at 13:38

ArnonZ

3,822
4
32
42

answered Nov 01 '12 at 08:33

Robert Ilbrink

7,738
2
22
32

This does not work for LibreOffice 5.1.622. There is no such menu item – gorn Oct 08 '17 at 14:25
I am still on 5.0.5.2 (where it still works...) and am now reluctant to upgrade to 5.1.622. – Robert Ilbrink Oct 09 '17 at 17:26

score 0 · Answer 2 · edited Jun 28 '18 at 22:02

0

It is available on LibreOffice 6.0.4.2 under Sheet -> Delete Page Break -> Row or Column Break

edited Jun 28 '18 at 22:02

Mohammad Kanan

4,452
10
23
47

answered Jun 28 '18 at 20:57

Ralph Peters

1
1

How can I remove manually added page breaks?

2 Answers2