From The Document Foundation Wiki
How do I print just one page, when my spreadsheet covers several pages?
To adjust the printing to a certain number of pages, follow these instructions:
- Open your sheet.
- Go to ▸ .
- In the dialog that appears, select the Sheet tab.
- At the bottom of this dialog, you will find a section labelled Scale.
- For the Scaling mode, select Fit print range to number of pages.
- Adjust the number of pages to the desired value.
- Click OK