Inserting Page Breaks, and Dragging the Page Breaks to Where You Want Them, in OpenOffice Calc

See also this post and this post on printing spreadsheets.

In Word, I believe, and possibly other applications, you can drag the default page breaks to where you want them, in print preview.

In OpenOffice.org Calc, there is no feature to do this in the page preview window.

But there sure as heck is one in the Page Break Preview window. You can insert page breaks, and drag default or inserted page breaks to where you want them.

Turning on Page Break Preview
Choose View > Page Break Preview. To turn it off, choose View > Normal.

Here's what it looks like.

Inserting a Manual Page Break
You can do this anytime, regardless of whether Page Break Preview is on. However, this illustration shows it on. Click on a row or column, and choose Insert > Manual Break. The appropriate selection will be available.

Dragging Page Breaks
Move your mouse over the page break and watch for the mouse pointer to turn into a two-ended arrow.

Then drag it right or left, up or down. The page break will change position accordingly.

If you drag an end or side page break into the document, then the column(s) or row(s) will appear as shown and they won't print. This is one way to control what prints, along with page ranges (select cells and choose Format > Print Ranges > Define for the first one in a document; Format > Print Ranges > Add for subsequent ones).

---

---

Comments

[christophe]

I'm having a page break problem that I can't solve using the information here. I inserted a new worksheet and created a table with data, formulas, etc. Under View>Normal, it looks normal. Under View>Page Break Preview, there are no page breaks and the background is completely grey, as when looking at sheets with page breaks, the area outside of the page. In a nutshell, I can't seem to get the program to allow me to insert a page break. So I have all of this information, and when I try to do a print preview, I can't even look at the page as the program doesn't recognize that there's anything on the page. Trying Insert>Manual Break>Column Break doesn't work either (the "column break" icon stays light grey and I can't click on it). Thanks for your help.

[Solveig]

Hi Christophe,

Sounds weird! Try seeing if you've got any page ranges setup? Choose Format > Print Ranges > Edit.

Solveig

[christophe]

Thanks, that worked. I went to Format>Print Ranges>Edit and selected "user defined" and that gave me the page break and the option to move it around as needed. I'm not sure why newly inserted sheets default to no page, but at least I now know how to create a page. Thanks again.

[michael]

thanks, that helped me too.

[adam]

http://www.batterygoshop.co.uk/toshiba/pa3356u-1brs-002-battery.htm 8.8ah Battery TOSHIBA PA3356U-1BAS PA3356U-1BRS PA3356U-2BRS ,