Guide to Printing in Google Sheets

Printing in Google Sheets can be challenging, but don't fear: this guide will teach you everything to know about printing in Google Sheets

Table of Contents
  1. How to simply print the whole sheet
  2. How to remove gridlines when printing
  3. How to print all sheets in the workbook
  4. How to fit the columns into one page or break the columns to several pages
  5. How to specify print area before printing
  6. How to change the paper size and orientation
Table of contents
Chapter 1
Chapter 2
Chapter 3
  1. How to simply print the whole sheet
  2. How to remove gridlines when printing
  3. How to print all sheets in the workbook
  4. How to fit the columns into one page or break the columns to several pages
  5. How to specify print area before printing
  6. How to change the paper size and orientation
5 Minutes

Sometimes we need to print the contents of our Google Sheets onto a piece of paper. In this tutorial, we will learn how to print sheets in Google Sheets. 

How to simply print the whole sheet

Google sheets allow you to print individual sheets. There are two ways:

  1. The Ctrl+P keyboard shortcut
  2. File > Print (the option is at the end of the drop-down menu)
File > Print

For our example we want to print the following sheet:

The sheet we want to print. 

When we press Ctrl+P or go to File > Print, this is what will appear:

Google Sheets’ print dialog

Google Sheets will start printing from the first column to the last column that contains data. To show this, let us add dummy data to the worksheet:

Original sheet with stray data.

What will be printed will look like this:

Google Sheets’ print dialog with stray data.

If you are satisfied with the way it looks, click Next. The system dialog for printing will appear. While the UI may depend on the system and the browser that you use, it will have options on the printer where you want to print it, the type of paper, the number of copies, and the pages to be printed. 

The computer’s print dialog

How to remove gridlines when printing

The Google Sheets’ print dialog has some options to modify the format before printing it. For example, you might want to remove the gridlines present in Google Sheets before printing. Here are the steps:

Step 1: Go to the print dialog by pressing Ctrl+P or File > Print. A sidebar is present on the right of the print preview. 

Step 2: Click Formatting.

Google Sheets’ print area. Formatting options highlighted in the sidebar.

When you click Formatting, additional options will appear.

Formatting options. Show gridlines enabled. 

Step 3: To hide the gridlines, simply untick Show gridlines. This is the result:

The print area, cleaner now. 

How to print all sheets in the workbook

It can be a hassle to print each sheet individually if there are a lot of them in the workbook. To print them all at once, follow the following steps:

Step 1: On the sidebar on the right side of the print dialog, there is a Print label, with a drop-down box listing the sheets to print. By default, the print dialog selects the current sheet active in Google Sheets. 

Step 2: Click the drop-down box, and select Workbook.

Print area options. Workbook selected.

From our original print settings that only covers one sheet that fits to one page:

Google Sheets’ print area. Only the current sheet is selected for printing. 

We now print the entire workbook with two sheets that has their own pages:

Google Sheets’ print area. The whole workbook is selected for printing. 

Fit the columns onto one page or break the columns onto several pages

You may need to print a spreadsheet that has several columns which may not fit in the single page:

The original sheet with several columns. 

Fortunately, the default option in Google Sheets is to fit all the columns to width:

Google Sheets’ print area. All the columns are squeezed into a single page. 

If you don’t want to fit all the columns to width and instead select the normal size, here are the steps:

Step 1: Go to the sidebar and look for the Scale.

Step 2: Click the box and select Normal (100%).

Scale options. The 100% scale enabled. 

The result is:

Google Sheets’ print area. The sheet is spread to two pages. 

As you can see, there are other options such as Fit to height, Fit to page, and Custom number. For the last one, a small box will appear where you will specify the scale:

The custom number option for scale selected. 75% scale specified. 

For example, if you specified 75% scale, the result would be:

Google Sheets’ print area, where the sheet is scaled to 75%.

Specify print area before printing

If you want to specify a specific range to print, here are the steps:

Step 1: Select the range that you want to print.

The original sheet, with the range that you want to print selected.

Step 2: Press Ctrl+P or File > Print to go to the print dialog.

Google Sheets’ print area. 

Step 3: Go to the sidebar, find the Print label, click the drop-down box below, then select Selected cells (range_of_selected).

Print range options. Highlighted cells selected. 

The print area is now:

Google Sheets’ print area. Only the selected cells are included in the print.

Change the paper size and orientation in Google Sheets

Finally, we will learn how to change the paper size and orientation. To do so, here are the steps:

Step 1: Go to the sidebar and look for Paper size and Page orientation

Print dialog sidebar. Paper size and page orientation shown. 

Step 2: By default, the page orientation is set to Landscape and the paper size is set to either Letter (8.5” x 11”) or A4 (8.27” x 11.69”). 

To change the page orientation to portrait, simply click the Portrait option. 

To change the paper size, click the drop-down box of options. 

Paper size options. 

You can also specify a custom size by selecting Custom size. Extra boxes for the width and height will appear. 

Height and width boxes appear when custom size is selected for paper size. 

The options will then be applied once the sheet is printed. 

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

June 8, 2022

Google Sheet spreadsheet

Sometimes we need to print the contents of our Google Sheets onto a piece of paper. In this tutorial, we will learn how to print sheets in Google Sheets. 

How to simply print the whole sheet

Google sheets allow you to print individual sheets. There are two ways:

  1. The Ctrl+P keyboard shortcut
  2. File > Print (the option is at the end of the drop-down menu)
File > Print

For our example we want to print the following sheet:

The sheet we want to print. 

When we press Ctrl+P or go to File > Print, this is what will appear:

Google Sheets’ print dialog

Google Sheets will start printing from the first column to the last column that contains data. To show this, let us add dummy data to the worksheet:

Original sheet with stray data.

What will be printed will look like this:

Google Sheets’ print dialog with stray data.

If you are satisfied with the way it looks, click Next. The system dialog for printing will appear. While the UI may depend on the system and the browser that you use, it will have options on the printer where you want to print it, the type of paper, the number of copies, and the pages to be printed. 

The computer’s print dialog

How to remove gridlines when printing

The Google Sheets’ print dialog has some options to modify the format before printing it. For example, you might want to remove the gridlines present in Google Sheets before printing. Here are the steps:

Step 1: Go to the print dialog by pressing Ctrl+P or File > Print. A sidebar is present on the right of the print preview. 

Step 2: Click Formatting.

Google Sheets’ print area. Formatting options highlighted in the sidebar.

When you click Formatting, additional options will appear.

Formatting options. Show gridlines enabled. 

Step 3: To hide the gridlines, simply untick Show gridlines. This is the result:

The print area, cleaner now. 

How to print all sheets in the workbook

It can be a hassle to print each sheet individually if there are a lot of them in the workbook. To print them all at once, follow the following steps:

Step 1: On the sidebar on the right side of the print dialog, there is a Print label, with a drop-down box listing the sheets to print. By default, the print dialog selects the current sheet active in Google Sheets. 

Step 2: Click the drop-down box, and select Workbook.

Print area options. Workbook selected.

From our original print settings that only covers one sheet that fits to one page:

Google Sheets’ print area. Only the current sheet is selected for printing. 

We now print the entire workbook with two sheets that has their own pages:

Google Sheets’ print area. The whole workbook is selected for printing. 

Fit the columns onto one page or break the columns onto several pages

You may need to print a spreadsheet that has several columns which may not fit in the single page:

The original sheet with several columns. 

Fortunately, the default option in Google Sheets is to fit all the columns to width:

Google Sheets’ print area. All the columns are squeezed into a single page. 

If you don’t want to fit all the columns to width and instead select the normal size, here are the steps:

Step 1: Go to the sidebar and look for the Scale.

Step 2: Click the box and select Normal (100%).

Scale options. The 100% scale enabled. 

The result is:

Google Sheets’ print area. The sheet is spread to two pages. 

As you can see, there are other options such as Fit to height, Fit to page, and Custom number. For the last one, a small box will appear where you will specify the scale:

The custom number option for scale selected. 75% scale specified. 

For example, if you specified 75% scale, the result would be:

Google Sheets’ print area, where the sheet is scaled to 75%.

Specify print area before printing

If you want to specify a specific range to print, here are the steps:

Step 1: Select the range that you want to print.

The original sheet, with the range that you want to print selected.

Step 2: Press Ctrl+P or File > Print to go to the print dialog.

Google Sheets’ print area. 

Step 3: Go to the sidebar, find the Print label, click the drop-down box below, then select Selected cells (range_of_selected).

Print range options. Highlighted cells selected. 

The print area is now:

Google Sheets’ print area. Only the selected cells are included in the print.

Change the paper size and orientation in Google Sheets

Finally, we will learn how to change the paper size and orientation. To do so, here are the steps:

Step 1: Go to the sidebar and look for Paper size and Page orientation

Print dialog sidebar. Paper size and page orientation shown. 

Step 2: By default, the page orientation is set to Landscape and the paper size is set to either Letter (8.5” x 11”) or A4 (8.27” x 11.69”). 

To change the page orientation to portrait, simply click the Portrait option. 

To change the paper size, click the drop-down box of options. 

Paper size options. 

You can also specify a custom size by selecting Custom size. Extra boxes for the width and height will appear. 

Height and width boxes appear when custom size is selected for paper size. 

The options will then be applied once the sheet is printed. 

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.