Quick Links:

As an Amazon Associate we may earn from qualifying purchases made via links on our website.

GuidesHow to print a Spreadsheet in Google Sheets

How to print a Spreadsheet in Google Sheets

Nowadays, as we have a digital era, everything becomes digitalized and Google Sheets isn’t an exception. Of course, it’s quite convenient, but there are some cases when you need a physical copy of the document. To print a single sheet or a whole workbook in Google Sheets, you will need to follow a few simple steps.

How to print a single spreadsheet in Google Sheets

  • 1. First of all, you should open Google Sheets.
  • 2. After that, you should sign in.
  • 3. Then, you should open the workbook.
  • 4. To print a single sheet, you should click on it to activate it.
  • 5. After that, you should head to “File“.
  • 6. In the end, you should tap on “Print” which is located in the menu.

On the right side, underneath the “Print” option, you will see the sheet that you want to be printed. The print settings can be adjusted also. To know how to do that, keep reading.

Take a note that Selected Cells can also be printed.

How to 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 and then Print.

  • Then, you need to click on “Workbook” which is located on the right side of the next screen below the “Print” option.
  • After that, you will see a drop-down box displayed for “Selection“. This option is set by default to all sheets. In order to print the whole workbook, you can miss this option and go down to the adjustments.
  • To print some particular sheets, you will need to click on the “Selection” drop-down box. Check the boxes next to the names of the sheets you want to be printed and tap on “Apply” to finish the process.

What adjustments there are in the print settings in Google Sheets

After you have selected the sheets which you want to be printed, you can adjust some options of the sheet such as the paper size and orientation, margins, formatting, and more.

Paper Size. To select the size of the sheet that you want to be printed, you should go to the drop-down list. In another way, you can tap on “Custom Size” and fill in the height and width.

Page Orientation. Here you can choose the Landscape or Portrait.

Scale. If you want your sheet to be scaled to suit in a special way, you can tap on the “Scale” option which you can find in the drop-down list. The default is 100%, but you can also choose to fit the sheet to width, height, or page. To choose the particular percent, you should tap on “Custom Number”.

Margins. Normal, Narrow, or Wide margins can be used to paste your sheet to the page as well. The margins can also be manually adjusted. To do that, you should pull the lines to the page and click “Custom Numbers”.

Set custom page breaks. This link is can be used when you print a single sheet. You can tap on this option and on the following screen pull the dotted lines to create your page intervals.

Formatting. There are a few options that are located under “Formatting” that can be adjusted. In this way, the gridlines and notes can be removed or displayed. The order of pages can also be adjusted in case there are several sheets. Also, the vertical or horizontal alignment can be selected.

Headers & Footers. This option will give you an opportunity to fill your printed piece with some details in the header or footer. Expand this section and check the boxes for the objects that you want to be contained such as page numbers, the sheet name, or the current date and time.

There is one more feature in the Headers & Footers section. You can duplicate frozen rows or columns. This allows you to have them set to all sheets that you want to be printed. You should also take a look at the box next to Repeat Frozen Rows, Repeat Frozen Columns, or both. If an option is grayed out, then there are no frozen rows or columns on your page.

So, as you can notice, Google Sheet isn’t complicated in usage at all.



Please enter your comment!
Please enter your name here

Related articles

More for you