Print a Spreadsheet or Workbook in Google Sheets - - Windows Tips and Tricks with Geek

Sunday, January 23, 2022

Print a Spreadsheet or Workbook in Google Sheets


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.

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


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.

Click Next on the top right

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.

No comments:

Post a Comment