How to Print a Google Sheet on One Page (Fit to Width)

By Gerard Fernandez · Updated · 2 min read

Printing a spreadsheet often gives you a stray column on page two or tiny text. The Print settings screen in Google Sheets fixes both, and it only takes a few clicks.

Open the print settings

Go to File → Print or press Ctrl + P (⌘ + P on Mac). A preview appears in the middle and the settings on the right:

Google Sheets print settings panel with Print set to Current sheet, Paper size Letter, Page orientation Landscape, Scale Fit to width, Margins Normal, Set custom page breaks, Formatting and Headers & footers
Real test: the settings panel. For our 3-column list, Sheets chose Landscape and Fit to width on its own.

Fit everything on one page

Open the Scale list and choose how to shrink the sheet:

Scale options in Google Sheets print settings: Normal (100%), Fit to width, Fit to height, Fit to page and Custom number
Real test: the Scale options.
OptionUse it when…
Normal (100%)The sheet is small and already fits
Fit to widthColumns spill onto a second page. All columns fit across; long tables still continue on more pages. Usually the best choice.
Fit to heightYou want all rows on one page, however many columns there are
Fit to pageEverything must be on a single page, even if the text gets small
Custom numberYou want an exact percentage, like 80%

For wide tables, also switch Page orientation to Landscape.

Select the cells first, then open File → Print and set Print to Selected cells. The same list lets you print the Current sheet or the whole Workbook. In our test the third option read Selected cells (C30), showing which cells it would print.

Tidy up the printout

  • Gridlines: under Formatting, untick Show gridlines for a cleaner page.
  • Repeat the header row: freeze the header row first; under Headers & footers, Repeat frozen rows repeats it at the top of every page. In our test it was already ticked because row 1 was frozen.
  • Page numbers: tick Page numbers under Headers & footers. The same section also offers Workbook title, Sheet name, Current date and Current time.

When the preview looks right, click Next to open your browser's print dialog, where you pick the printer or Save as PDF.

Frequently asked questions

Why is there a blank page at the end?

Some cell outside your table has content or formatting, often a stray space. Print Selected cells instead, or clear the extra cells.

How do I choose where pages break?

Click Set custom page breaks in the settings and drag the blue lines to where you want each page to end.