Disclaimer: MashTips is supported by its audience. When you purchase through links on our site, we may earn an affiliate commission at no extra cost to you.

Home Google How to Print Selected Area in Google Sheets

How to Print Selected Area in Google Sheets

Usually, it is very convenient to view a Google Spreadsheet on the go either on your smartphone or a laptop. However, a hard copy will come handy especially if you would like to mark or analyze only specific rows/columns. And, when it comes to printing, Google Sheets is so flexible that you can print only the information you need instead of the entire sheet or workbook.

In this article, let’s take a look at how to customize print options in Google Spreadsheet.

How to Set Print Area in Google Sheets

Whether you need to print only specific cells, an entire Spreadsheet or other kinds of selection, you can exactly set the print area on Google Sheets based on your need.

How to Print Only Specific Cells in Google Sheets

Let’s assume that you are organizing an event in your company and you are assigned a list of tasks. Now, let’s say that you would like to print only the tasks for a specific day. Let’s see how to do that.

  1. On your browser, navigate to sheets.google.com.
  2. Next, open the Google Spreadsheet you would like to print. (Make sure you are logged in to the Google account)
  3. Then, select the cells you wish to print.
    – If you are using a keyboard, you can select a cell, press & hold CTRL key and select remaining cells.
    – If you are using a mouse, then you can hold the left-click button and simply drag the mouse to select the desired cells. Google sheets select cells
  4. Once the cells are selected, release the CTRL key or left-click mouse button.
  5. Next, click Print icon located on the top-left of the screen. Alternatively, you can press CTRL and P keys on your keyboard. Or you can navigate to File->Print from the menu.
  6. Here, a print menu will appear on the right side of your screen. On the left, you will see the print preview of your current page.
  7. In the print menu, click the drop-down box under the title Print and select Selected cells. By default, the option Current Sheet will be selected.Google sheet print selected cells
  8. Now, your print preview will be switched to your selected cells as shown below:Google sheets print preview selected cells
  9. Then, click Next button and follow the on-screen instructions to print the specific cells on your Google Spreadsheet.

You can follow the above steps to print a set of specific cells, rows or columns. 

Related: How to Share Specific Sheet from Google Spreadsheet

How to Print a Single Google Spreadsheet

Let’s assume that you are working on a Google Spreadsheet with multiple sheets. And, you would like to print only a specific sheet. (eg. Sheet titled ‘Week 2’) Let’s see how to do that.

  1. Repeat Steps 1 and 2 mentioned in the section How to Print Only Specific Cells in Google Sheets.
  2. Next, open the sheet you need to print and click Print icon or press CTRL and P keys on your keyboard.
  3. Here, a print menu will appear on the right side of your screen. On the left, you will see the print preview of your current page.
  4. In the print menu, the option Current Sheet (default) will be selected in the drop-down box titled Print. If not, click the arrow in the drop-down box and select Current Sheet option.Google sheet print current sheet
  5. Finally, click Next button to print the current sheet of your workbook.

How to Print Entire Workbook in Google Sheets

Let’s say that you need to print an entire workbook instead of a single sheet or specific cells. Follow the below steps to print the entire workbook.

  1. Repeat Steps 1 and 2 mentioned in the section How to Print Only Specific Cells in Google Sheets.
  2. Click Print icon or press CTRL and P keys on your keyboard.
  3. In the print menu (located on the right), select the value Workbook from the drop-down box titled Print.Google sheet print workbook
  4. Then, click Next to print the entire workbook.

Also Read: How to Swap Values Between Cells, Rows or Columns in Google Sheets

How to Customize Print Options in Google Sheets

Besides configuring the print area, Google Sheets has several print options like adjusting margins, selecting paper size, inserting headers/footers and more.

Adding Headers & Footers

Let’s say you are printing a long workbook of more than 10 pages. Won’t it look better if you can print the page numbers so that you can arrange the sheets easily? With a single click, you can add page numbers, date, time, name of the sheet/workbook. Let’s see how to do that.

  1. Repeat Steps 1 to 3 mentioned in the section How to Print an Entire Google Spreadsheet.
  2. In the print menu, look for the title Headers & footers. Under that, you will find multiple checkboxes to add the page numbers, date, time, etc. Once you select the checkboxes, the print preview pane on the left will be updated accordingly.Google sheet print header footer
  3. Click Next to print the page.

Adjust Margins

If you need to print a Google sheet with a lot of columns on a single paper, then this setting will come handy. In the print menu, look for the section titled Margins. When you click that drop-down box, you will see four options: Normal, Narrow, Wide, Custom Numbers. If you select Custom Numbers, you can see the margin markers on the print preview displayed on the left side of your screen. Then, you can just adjust the margins with your mouse based on your requirements. 

Google sheet print adjust margins

Formatting

Apart from adjusting page margins, you can also change the horizontal/vertical alignment of the sheet to Left/Right/Center. If you wish to print the gridlines, then you can select the checkbox titled Show gridlines. All these settings are available in the Formatting section of the Print window.

Google sheet print formatting options

Configure Paper Size

By default, the paper size is set to Letter (8.5″x 11″). However, you can select the paper size to any of the 10+ options (A3, A4, A5, B4 and so on) listed under the drop-down menu Paper size on the Print window that appears, after you click Print icon or CTRL+P keys on your keyboard. In addition to the pre-defined paper size, you can also set your own paper size by selecting the value Custom size and entering values for Height and Width.

Google sheet print set paper size

Apart from the above-listed settings, you can also set Page orientation (Portrait/Landscape), insert custom page breaks and scaling as well.

By now, we hope you should have gained a good amount of knowledge on printing Google Spreadsheets and customizing the print options. 

Have we missed any other settings or options related to printing Google Sheets? If yes, please share that in comments.

Leave a Reply

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

Holiday Gift Ideas 2020

15 Best Drones for Kids and Beginners to Buy in 2020

RC Drones have become very common nowadays. Lots of kids are developing an interest in it as a toy due to its distinctive features....

12 Best Xbox Gift Ideas for Xbox Fans in 2020

Each and every person who heard about the new generation Xbox consoles will love to have one. Who doesn't want his hands on the...

20 Cool Gadgets Gifts for Men in 2020

Holidays are nearly upon us and considering the year we've had so far, people perhaps would cherish this opportunity to celebrate and forget about...

12 Best PlayStation Gift Ideas for PlayStation 5 Fans in 2020

Who wouldn't love gifts, especially when it is a gaming console? For all those who plan to surprise their beloved ones with the latest...

Free Newsletter

Related Articles

Search Google by SMS from your phone.

This free service from Google is good for those who are still using the ordinary phone with out internet connection. A smart phone user...

How to Add Suggested Apps to Dock on Android Phone

Apple's approach to software design is to control every aspect of the experience. Other companies like Samsung allow users a lot of choices instead....

How to Identify Fake Apps in Google Play Store?

Google Play Store is home to millions of Android apps. At the same time, it is also home to fake apps looking to steal...

Search MP3 Songs & Download with Google Search Engine

With Search Engines like Google and Bing, you can search Mp3 and other songs and download songs to your computer directly from the browser. There is...