From The Document Foundation Wiki
Jump to: navigation, search

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 Format ▸ Page.
  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.