iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
To print a Google Sheet on one page, open it on a computer, select File > Print, choose what to print, and adjust the scale in the print preview to fit the whole sheet onto one page if that option is available. Check the preview before printing: fitting a large sheet to one page can make its text too small to read. If legibility matters more, fit the sheet to the page width and let it continue vertically across multiple pages.
Print a Google Sheet on one page
- Open the print settings. In the spreadsheet on a computer, select File > Print.
- Choose what to print. Select Current sheet for the active tab, Workbook for the spreadsheet, or Selected cells after selecting the range you need.
- Choose orientation and paper size. Try Landscape for a wide range or Portrait when the layout is taller than it is wide. Select the paper size you plan to use; Google Sheets also allows custom height and width values.
- Adjust margins. Choose a preset or enter custom margin measurements. Narrower margins may leave more room for the cells, but confirm that the intended printer can handle the layout.
- Set the scale. In the preview, choose the option that fits the entire sheet to one page, if it appears in your print panel. Scale labels can vary; Google’s help page describes the print controls but does not enumerate the available scale choices. Inspect the preview to make sure the text remains readable.
- Continue to print or save as a PDF. Select Next. Google says Chrome opens a print window; Firefox or Safari automatically downloads a PDF that you can print from a PDF viewer.
For Google’s documented print workflow and settings, see Print from Google Sheets – Computer.
Choose between fitting the sheet to one page and fitting its width
These are different goals. Fit to page aims to keep both the columns and rows on one page, so a large sheet may be reduced substantially. Fit to width keeps the columns together horizontally but allows the sheet to span multiple pages vertically. A 2025 CICILearning training-guide example shows a Fit to width scale setting; treat it as an interface example, and check which scale choices appear in your current print panel.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problemsIf a one-page version is difficult to read, use fit to width or another less restrictive scale rather than forcing the whole range onto one page. You can also print only the relevant cells to avoid shrinking unrelated content.
#1 Best Overall
- 1 ream (500 sheets) of 8.5 x 11 white copier and printer paper for home or office use
- Multipurpose letter size copy paper works with laser/inkjet printers, copiers and fax machines
- Smooth 20lb weight paper for consistent ink and toner distribution; dries quickly and resists paper jams
- Bright white paper (92 GE; 104 Euro) offers great contrast for crisp printing and vivid color
- Virgin copy paper providing professional quality results; acid-free to prevent yellowing
Pick the right print scope, orientation, and paper
| Setting | Use it when |
|---|---|
| Current sheet | You need only the active sheet tab. |
| Workbook | You want to print the spreadsheet as a whole. |
| Selected cells | You want a specific range rather than the entire sheet. |
| Portrait | The selected range is taller than it is wide. |
| Landscape | The selected range is wider than it is tall. |
Orientation is a useful first adjustment for a broad table, but check the preview with the paper size and margins you intend to use. Custom paper dimensions can be entered by height and width.
Control page breaks and repeat labels
Set custom page breaks
For a multi-page printout, open the print screen and choose Set custom page breaks. Drag the break lines to change where pages split, then confirm. Each rectangle shown in the guide’s description prints as a separate page.
Rank #2
- HP Papers is sourced from renewable forest resources and has achieved production with 0% deforestation in North America. Each ream is wrapped in a polyurethane coated paper wrapper to protect the cut sheets from moisture damage
- Sheet size – 8.5 x 11; Thickness – 20 pounds; Brightness – 92 bright white
- HP Copy&Print20 20 pounds printer paper is Forest Stewardship Council (FSC) certified and contributes toward satisfying credit MR1 under LEED (Leadership in Energy and Environmental Design)
- All HP Papers provide premium performance on HP equipment, as well as on all other printer and copier equipment; 100% satisfaction guaranteed; ColorLok technology provides more vivid colors, bolder blacks and faster drying
- Superior quality, reliability, and dependability for high-volume printing at home, at school and in the office; HP Copy&Print20 print and copy paper prevents yellowing over time to ensure a long-lasting appearance for added archival quality
Repeat frozen rows or columns
If a table spans several pages, freeze the row or column that contains its labels in the sheet first. Then, in print settings, open Headers & footers and select Repeat frozen rows or Repeat frozen columns. This places those frozen labels on additional printed pages.
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchAdd headers and footers
In print settings, open Headers & footers to choose which information to include. Use the custom-field controls to change formatting or location.
Rank #3
- 3 ream case (1,500 sheets) of 8.5 x 11 white copier and printer paper for home or office use
- Multipurpose letter size copy paper works with laser/inkjet printers, copiers and fax machines
- Smooth 20lb weight paper for consistent ink and toner distribution; dries quickly and resists paper jams
- Bright white paper (92 GE; 104 Euro) offers great contrast for crisp printing and vivid color
- Virgin copy paper providing professional quality results; acid-free to prevent yellowing
Check the print preview before sending the job
- Confirm that the print scope includes only the intended sheet or cells.
- Check that the selected paper size and orientation suit the range.
- Make sure text is readable at the chosen scale and that important columns or rows are not split awkwardly.
- For a multi-page printout, check the page breaks and whether repeated frozen labels are included where needed.
Google documents these desktop settings, but does not provide a complete compatibility matrix for browsers, operating systems, printer drivers, or mobile devices. The steps above describe the computer print workflow.
Quick Recap
Best Value
- 8 ream case (4,000 sheets) of 8.5 x 11 white copier and printer paper for home or office use
- Multipurpose letter size copy paper works with laser/inkjet printers, copiers and fax machines
- Smooth 20lb weight paper for consistent ink and toner distribution; dries quickly and resists paper jams
- Bright white paper (92 GE; 104 Euro) offers great contrast for crisp printing and vivid color
- Virgin copy paper providing professional quality results; acid-free to prevent yellowing
Rank #4
- 5 ream case (2,500 sheets) of 8.5 x 11 white copier and printer paper for home or office use
- Multipurpose letter size copy paper works with laser/inkjet printers, copiers and fax machines
- Smooth 20lb weight paper for consistent ink and toner distribution; dries quickly and resists paper jams
- Bright white paper (92 GE; 104 Euro) offers great contrast for crisp printing and vivid color
- Virgin copy paper providing professional quality results; acid-free to prevent yellowing
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
