How to ensure Calc prints worksheet on one page?

I am using LibreOffice as a cash and analysis book. The totals at the bottom of the first page appear on row 52 which appears on page two when printed. How can I get these totals as the bottom row of page one [approximately row 46]?

Select the area you want to print, then go to “Print Preview”.

On the preview you’ll see a Format Page button. Click it.

Then click on the right-end tab, Sheet, and choose the “Scale” option, set to print on one page:

Click OK - your worksheet should now print on a single page.