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. You can follow the above steps to print a set of specific cells, rows or columns.
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.
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.
How to Customize Print Options in Google Sheets
Besides configuring the print area, Google Sheets has several print options like adjusting margins, selecting the 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.
Adjust Margins
If you need to print a Google sheet with a lot of columns on a single piece of paper, then this setting will come in 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.
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.
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 the 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.
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. Notify me of follow-up comments by email. Notify me of new posts by email.
Δ
