When you press Print in Google Sheets, it only prints the tab you’re looking at. If your spreadsheet has several tabs, such as monthly data, a summary and charts, you can print all of them in one go by switching one setting in the print preview. This guide shows how to print the whole workbook, choose only certain sheets, make every sheet fit neatly on the page, and save the workbook as a single PDF.
Quick Answer
Click File > Print (or press Ctrl + P, or Command + P on a Mac). At the top of the right panel, change Print from Current sheet to Workbook, check the sheets you want, click Next, and print.
How to Print an Entire Workbook in Google Sheets
- Open the spreadsheet in Google Sheets in a web browser.
- Click File > Print, press Ctrl + P, or click the printer icon on the toolbar.
- In the Print settings panel on the right, click the Print dropdown at the top (it says Current sheet).
- Select Workbook.
- Check or uncheck the sheets you want to include. All sheets are checked by default.
- Adjust paper size, orientation, scale and margins if needed. The preview on the left updates and shows the total page count.
- Click Next.
- In your browser’s print dialog, pick your printer and click Print.
Print Only Some Sheets
After choosing Workbook, uncheck any sheets you don’t need. Hidden sheets aren’t printed. If you need to print a single tab, leave the setting on Current sheet and open that tab first.
Make Every Sheet Fit on the Page
- Scale: choose Fit to width so no columns spill onto extra pages, or Fit to page to squeeze each sheet onto one page. Custom number lets you set a percentage.
- Orientation: choose Landscape for wide sheets.
- Margins: choose Narrow to fit more on each page.
- Formatting: check Show gridlines if you want cell lines printed, and use Headers & footers to add page numbers, the sheet name or the date. Adding the sheet name is especially helpful when printing a workbook.
- Repeat header rows: freeze the top row (View > Freeze > 1 row), then check Repeat frozen rows under Headers & footers so column titles appear on every page.
These settings apply to every sheet in the workbook print job.
Save the Whole Workbook as One PDF
- From Print: choose Workbook, click Next, then choose Save as PDF (or Microsoft Print to PDF) as the printer.
- From Download: click File > Download > PDF (.pdf). The same settings panel opens; choose Workbook under Export, then click Export.
Printing From a Phone or Tablet
In the Google Sheets app, tap the three-dot menu, then Share & export > Print. The app usually prints the current sheet only. To print every sheet, open the spreadsheet in a browser on a computer, or save the workbook as a PDF from a computer first.
To number pages in the header, read how to put Google Sheets page numbers at the top.
Troubleshooting
- Workbook option missing: the spreadsheet has only one visible sheet. Unhide sheets from the All Sheets list (the icon with four lines at the bottom left).
- Blank pages: formatting or stray content in far-off cells can create extra pages. Delete unused rows and columns, or set a print range with Selected cells.
- Charts cut off: move charts inside the data area or give them their own sheet with Move to own sheet in the chart menu.
- Can’t print: if the owner turned off printing for viewers and commenters, the Print option is unavailable. Ask for edit access.
Frequently Asked Questions
Does printing the workbook include hidden sheets?
No. Only visible sheets appear in the list. Unhide a sheet to print it.
Can I use different settings for each sheet?
Not in one print job. Print sheets separately if you need different orientation or scaling for each.
Will each sheet start on a new page?
Yes. Each sheet begins on a new page in the printout.
Is there a keyboard shortcut?
Ctrl + P on Windows and Chromebook, or Command + P on a Mac, opens print settings. You still need to choose Workbook.
Summary
- Press Ctrl + P or choose File > Print.
- Change Print from Current sheet to Workbook.
- Choose sheets and adjust scale and orientation.
- Click Next and print or save as PDF.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.