Skip to content

← Using a Computer, in Practice

Spreadsheets · 64 of 111

Fit a sheet to one page before you print

Expert guidance

Do this

Google Sheets: File, Print. Choose Landscape if it’s wide. Under Scale, choose Fit to width (that one’s from everyday use).

LibreOffice Calc:

  1. Select the cells, and choose Format, Print Ranges, Define.
  2. Choose Format, Page Style, and open the Sheet tab.
  3. Under Scale, set Scaling mode to Shrink print range(s) to width/height, with Width in pages at 1.
  4. Check with File, Print Preview.

Why this way

Text that’s too small is no better. If it’s hard to read, hide columns you don’t need, or print landscape. LibreOffice’s help notes that a sheet with no print range may not print at all. To add headings on each page, see Format, Print Ranges, Edit. Expert guidance.

Do it today

Preview your longest sheet. How many pages does it need? Two minutes.

Where these facts come from

General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.

← All 111 things to do