How to Print Google Sheets: Full Guide

What You’ll Need

A Google account and a Google Sheet with data you want to print
A printer set up (or the ability to save as PDF)
Web browser (Chrome, Firefox, Safari, Edge) or the Google Sheets mobile app

Step-by-Step

Open your Google Sheet – Go to sheets.google.com and open the spreadsheet you want to print. Make sure you’re signed in to the correct Google account.
Start the print dialog – Click File in the top menu, then select Print. Alternatively, press Ctrl+P (Windows) or Cmd+P (Mac) to skip the menu.
Choose what to print – In the print preview panel on the right, under Print, select one of: Current sheet, Workbook, Selection (if you highlighted cells first), or Custom (to manually pick cells).
Adjust the layout – Under Layout, choose Portrait (tall) or Landscape (wide). For wide sheets, landscape often fits more columns on a page.
Set the scale – Under Scale, pick Fit to page to shrink everything to one page, or choose Custom and enter a percentage (e.g., 50% to make it smaller).
Adjust margins and headers – Set Margins to Normal, Narrow, or Custom. In Formatting, check or uncheck Show gridlines, Show notes, and Repeat row headers (useful for multi-page sheets).
Preview the pages – Use the page thumbnails on the left to see how your data will look. Use the arrow buttons or click a thumbnail to check each page.
Choose the printer – In the Destination dropdown, select your printer, or choose Save as PDF to create a digital copy instead of a physical print.
Print – Click the blue Next button, then in the system print dialog click Print (or Save if you chose PDF).

Common Mistakes

Printing the whole workbook – If you only need one sheet, make sure you select “Current sheet” in the print settings; otherwise, you’ll print every tab.
Columns cut off – When the scale is set to “Actual size” or too high, columns may spill onto extra pages. Use “Fit to page” or reduce the scale percentage.
Gridlines missing – If you want the cell lines, check the “Show gridlines” box in the Formatting section. It’s off by default.
Printing blank pages – Extra empty rows or columns can cause blank pages. Select only the range you need, or clear the unused cells before printing.
Headers not repeating – For multi-page prints, enable “Repeat row headers” so the top row appears on every page.

Tips

Use Ctrl+P (or Cmd+P) to open the print dialog quickly from anywhere in the sheet.
Preview before printing – the thumbnail view saves paper and ink by catching issues early.
Save as PDF if you want to email the sheet or print later – it’s faster and uses no ink.
For large sheets, consider splitting the data into multiple sheets and printing each separately.
Adjust the print area by selecting the cells you want, then in the print dialog choose “Selection” – this is perfect for printing just a table.
On mobile, tap the three-dot menu and choose “Share & export” > “Print” – the options are similar but may vary slightly by app version.

Troubleshooting

Print button is grayed out – Make sure you have edit access to the sheet (not just view-only). If you’re in view mode, you may need to request edit permission.
Print preview is blank – Check that you have data in the selected range. Also, clear any filters that might be hiding rows.
Columns are too wide – Go back to the sheet, select the columns, and reduce their width, or use “Fit to page” in the print settings.
Printout looks different from preview – This usually happens when the printer driver scales differently. Try saving as PDF first, then print the PDF.
Can’t find the printer – Ensure your printer is connected and set as default. In the destination dropdown, choose “See more” to search for it.
Mobile app doesn’t have print option – On the Google Sheets app, tap the three-dot menu, then “Share & export” > “Print”. If it’s missing, update the app or use the web version in a mobile browser.

Frequently Asked Questions

How do I print only selected cells in Google Sheets?

Select the cells you want to print, then go to File > Print. In the print dialog, under “Print”, choose “Selection”. The preview will show only those cells.

Can I print gridlines in Google Sheets?

Yes. In the print preview, under “Formatting”, check the box for “Show gridlines”. This adds the cell borders to the printed page.

How do I make everything fit on one page?

In the print dialog, under “Scale”, select “Fit to page”. This will shrink the content to fit on a single page. You can also adjust margins to “Narrow” to give more space.

Why is my Google Sheet printing blank pages?

Blank pages often appear because of empty rows or columns. Select only the range you need, or delete unused rows/columns. Also check that the print area isn’t set to include extra cells.

Can I print multiple sheets at once?

Yes. In the print dialog, under “Print”, choose “Workbook”. This will print all sheets in the file. Each sheet will start on a new page.

How do I print row headers on every page?

In the print dialog, under “Formatting”, check “Repeat row headers”. This will repeat the top row(s) on every printed page.

Sources: Google Workspace Help. Menus and buttons can differ slightly by version. Spotted something out of date? Tell us.