← 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:
- Select the cells, and choose Format, Print Ranges, Define.
- Choose Format, Page Style, and open the Sheet tab.
- Under Scale, set Scaling mode to Shrink print range(s) to width/height, with Width in pages at 1.
- 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
- Print from Google Sheets, Google Docs Editors Help.
- Sheet (Page Style), LibreOffice Help.
- Using Print Ranges on a Spreadsheet, LibreOffice Help.
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.
