While many spreadsheets are now shared digitally, there may be a situation where you need a physical copy. In Google Sheets, you can print a single sheet or an entire workbook and adjust the appearance in a few steps.

Print the Current Spreadsheet in Google Sheets

Visit Google Sheets, sign in if necessary, and open the workbook. If you want to print one particular sheet, select that one to make it active. Then, go to File > Print in the menu.

Select File, Print in Google Sheets

You should see your selected sheet and on the right side under Print, you’ll see Current Sheet. You can then adjust the print settings we’ll explain in detail below.

Select Current Sheet

Notice you can also choose to print Selected Cells. Check out our how-to for printing a specific selection of cells in Google Sheets.

Print the Workbook or Multiple Sheets

If you want to print an entire workbook or several sheets within it, you can have any sheet active when you click File > Print.

Advertisement

On the right side of the next screen below Print, select “Workbook.” You’ll then see a drop-down box appear beneath for Selection. By default, this is set to All Sheets. So if you want to print the entire workbook, you can leave this setting and move on to the adjustments.

Select Workbook and All Sheets

If you only want to print certain sheets, click the Selection drop-down box. Check the boxes next to the names of the sheets you want to print and click “Apply.”

Select the sheets to print

Adjust the Print Settings in Google Sheets

Once you choose which sheets you want to print, you have a variety of settings you can adjust like the paper size and orientation, margins, formatting, and more.

Paper Size: Use the drop-down list to select the size of the paper you’re printing on. You can also pick “Custom Size” and enter the height and width.

Page Orientation: Select either Landscape or Portrait.

Select the paper size and page orientation

Scale: If you need to scale the sheet to fit a particular way, use the drop-down list to select a Scale option. Normal is 100 percent, but you can also choose to fit the sheet to width, height, or page. Pick “Custom Number” to scale it to a certain percent.

Choose a Scale option

Margins: You can use Normal, Narrow, or Wide margins to fit your sheet to the page as well. Select “Custom Numbers” to manually adjust the margins by dragging the lines on the sheet.

Adjust the margins

Advertisement

Set Custom Page Breaks: This link is available when you print a single sheet. You can click this option and on the following screen drag the dotted lines to create your page breaks.

Set the custom page breaks

Formatting: You have several options under Formatting that you can adjust. You can show or hide the gridlines and notes, select the page order if you have more than one page, and choose the horizontal and vertical alignment.

Choose the Formatting options

Headers & Footers: One handy print setting allows you to add details to your printed piece in the header or footer. Expand this section and check the boxes for the items you want to include such as page numbers, the sheet name, or the current date and time.

Add items to the header or footer

You can also edit the available fields for specific details or formatting if you like. Click “Edit Custom Fields” and then use the areas in the header or footer on the next screen to choose what you’d like to display.

Edit the custom fields in the header or footer

Another option in the Headers & Footers section is to repeat frozen rows or columns. This lets you display those on all pages you print. Check the box next to Repeat Frozen Rows, Repeat Frozen Columns, or both. If an option is grayed out, then you don’t have any frozen rows or columns in your sheet.

Repeat frozen rows or columns

Download the File From Google Sheets

After you make your adjustments and are ready to print, click “Next” on the top right.

Advertisement

You’ll then receive your sheet as a PDF file. Depending on the browser you use and your settings, the PDF may download automatically, or you may be prompted to open or save the file.

Open and save options in Firefox

Once you have the PDF, simply print it as you normally would on your computer.

If you’d like help printing from other Google applications, take a look at how to print a Google Slides presentation or a Google Doc with comments.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »