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.
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.
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).