Sign inTry for freePrinting in Google Sheets can be challenging, but don't fear: this guide will teach you everything to know about printing in Google Sheets
.png)
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.
Google sheets allow you to print individual sheets. There are two ways:
For our example we want to print the following sheet:
When we press Ctrl+P or go to File > Print, this is what will appear:
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:
What will be printed will look like this:
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 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.
When you click Formatting, additional options will appear.
Step 3: To hide the gridlines, simply untick Show gridlines. This is the result:
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.
From our original print settings that only covers one sheet that fits to one page:
We now print the entire workbook with two sheets that has their own pages:
You may need to print a spreadsheet that has several columns which may not fit in the single page:
Fortunately, the default option in Google Sheets is to fit all the columns to width:
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%).
The result is:
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:
For example, if you specified 75% scale, the result would be:
If you want to specify a specific range to print, here are the steps:
Step 1: Select the range that you want to print.
Step 2: Press Ctrl+P or File > Print to go to the print dialog.
Step 3: Go to the sidebar, find the Print label, click the drop-down box below, then select Selected cells (range_of_selected).
The print area is now:
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.
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.
You can also specify a custom size by selecting Custom size. Extra boxes for the width and height will appear.
The options will then be applied once the sheet is printed.
