Faq/Calc/104/en

How to control the printing zoom to limit the number of pages for printing
Suppose you want your table to be limited to one page in width, but the number of pages in height can be variable. To adjust the printing to a certain number of pages, when you don't know the total number of pages that would be obtained, follow these instructions:
 * 1) Open your sheet.
 * 2) Go to.
 * 3) In the dialog that appears, select the Sheet tab.
 * 4) At the bottom of this dialog, you will find a section labeled Scale.
 * 5) Choose the scale mode Fit print range(s) to width/height.
 * 6) Adjust the number of pages in the width and height boxes to the desired value (1 for the width in our example).
 * 7) Adjust the other number (height in our example) to a very large value.
 * 8) Click OK.
 * 9) View the results in Print Preview.

Another, more "hands-on", technique consists of adjusting the percentage of zoom by using the scale mode Reduce/enlarge printout as explained here.