Skip to content

How to Print in Google Sheets

This article will show you how to print a worksheet in Google Sheets. We will also cover how to adjust some important print settings as well.

How to Print a Worksheet

To print a worksheet in Google Sheets, follow the steps listed below.

In the Google Sheets tab menus, go to File > Print.

You can also use the keyboard shortcut CTRL + P or click on the Print button in the Google Sheets Toolbar.

The Print settings window will appear. When you are ready to print, click on Next and then click Print.

Adjusting the Settings

Here are some settings you might want to adjust when printing your worksheet.

Change What to Print

Instead of printing the entire worksheet, you can change the settings to print only the selected cells or the entire workbook.

For example, here is how to only print a specific selection of cells.

Start by selecting the range of cells you would like to print.

Next, click on the Print button or use the shortcut CTRL + P.

In the Print settings window change Current Sheet to Selected cells.

Finally, click Next and then click Print.

Change the Orientation

You have the option to switch between Portrait Orientation and Landscape Orientation before you print.

To change the orientation, simply select the Page orientation option you wish to apply.

Adjust the Page Margins

To adjust the page margins, follow the steps listed below.

Under the Margins section, click where it reads Normal and select either Narrow or Wide.

If you would like to customize the margins even further, click on Custom numbers. You can now change any of the margins in the preview window on the Print settings page.

Change the Scale

If you want to fit a worksheet with lots of data onto a single page, click where it reads Fit to width under the Scale section. You can then change the scale to fit your needs and you can click on Custom number to further customize your scaling options.

This Post Has One Comment

  1. You never know how different Google Sheets is from Excel until you try it out! Thanks for the help here, I would have never thought of the differences.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top