How to Print Specific Cells, Area or Entire Sheet in Google Spreadsheet

Commonly, it is very ready to hand to view a Google Spreadsheet happening the go either along your smartphone or a laptop. Nevertheless, a hard copy leave issue forth W. C. Handy especially if you would like to mark or analyze alone specific rows/columns. And, when information technology 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 clause, let's take away a look at how to customize print options in Google Spreadsheet.

How to Set Impress Area in Google Sheets

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

How to Print Only Precise Cells in Google Sheets

Countenance's seize that you are organizing an event in your troupe and you are assigned a list of tasks. Now, permit's say that you would like to print only the tasks for a specific day. Let's see how to do that.

On your browser, navigate to sheets.google.com.
Next, surface the Google Spreadsheet you would like to print. (Make a point you are logged in to the Google account)
Then, select the cells you like to print.
– If you are using a keyboard, you lavatory quality a cell, press & hold CTRL key and select remaining cells.
– If you are using a mouse, then you keister hold the left-click button and just drag the mouse to select the desired cells.
Erst the cells are selected, release the CTRL key fruit Beaver State left-click mouse button.
Succeeding, click Print icon located on the top-left of the screen. Alternatively, you dismiss press CTRL and P keys on your keyboard. Or you can pilot to File->Print from the menu.
Here, a mark bill of fare will appear on the powerful English of your screen. On the unexpended, you will see the print preview of your current page.
In the photographic print menu, click the drop-lowered box under the title Printand select Selected cells. Away default, the option Current Sheet will be selected.
Now, your print trailer will make up switched to your selected cells Eastern Samoa shown below:
Then, click Adjacent button and follow the on-screen instructions to photographic print the peculiar cells on your Google Spreadsheet.

You pot follow the in a higher place stairs to print a set of limited cells, rows OR columns.

Related: How to Share Unique Sheet from Google Spreadsheet

How to Print a Single Google Spreadsheet

Let's take that you are working on a Google Spreadsheet with multiple sheets. And, you would equivalent to print only a specific sheet. (eg. Sheet coroneted 'Workweek 2') Let's go through how to do that.

Repeat Steps 1 and 2 mentioned in the section How to Print Only Specific Cells in Google Sheets.
Next, open the sheet you need to print and click Photographic print icon or imperativeness CTRL and P keys on your keyboard.
Hither, a print computer menu will appear happening the right side of your test. Connected the left, you will see the print prevue of your current page.
In the print menu, the selection Current Sheet (default) will be selected in the drop-down box seat styled Impress. If not, click the arrow in the drop-perfect box and select Underway Sheet option.
Finally, click Next push to impress the current sheet of your workbook.

How to Print Entire Workbook in Google Sheets

Let's read that you need to print an entire workbook instead of a single sail or taxon cells. Conform to the below stairs to print the entire workbook.

Repetition Steps 1 and 2 mentioned in the section How to Print Only Taxonomic category Cells in Google Sheets.
Flick Print icon or press CTRL and P keys on your keyboard.
In the print computer menu (placed on the right), select the value Workbook from the drop-set box titled Print.
And so, click Next to mark the total workbook.

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

How to Customize Mark Options in Google Sheets

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

Adding Headers &ere; Footers

Let's say you are printing a long workbook of more than 10 pages. Won't it look best if you can print the page numbers so that you can arrange the sheets easy? With a single snap, you stern add page numbers, date, time, distinguish of the canvas/workbook. Let's visit how to Doctor of Osteopathy that.

Repeat Steps 1 to 3 mentioned in the section How to Print an Entire Google Spreadsheet.
In the black and white carte, look for the title Headers & footers. Under that, you will find twofold checkboxes to add the page numbers, date, time, etc. Once you choice the checkboxes, the photographic print preview pane on the left bequeath Be updated accordingly.
Clack Succeeding to photographic print the paginate.

Adjust Margins

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

Google sheet print adjust margins

Formatting

Separate from adjusting page margins, you can too change the horizontal/vertical alignment of the flat solid to Left-of-center/Right/Center. If you wish to print the gridlines, and so you can select the checkbox titled Evidenc gridlines. All these settings are available in the Formatting section of the Print window.

Google sheet print formatting options

Configure Report Size

By default on, 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 etcetera) listed under the drop-behind menu Paper size on the Print windowpane that appears, after you detent Print ikon operating theatre CTRL+P keys on your keyboard. In gain to the pre-defined report size, you can also set aside your own newspaper size by selecting the value Bespoke size of itand entering values for Height and Width.

Google sheet print set paper size

Separate from the above-listed settings, you can also fixed Page orientation (Portrayal/Landscape), insert custom page breaks and scaling besides.

By in real time, 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 portion that in comments.

Disclosure: Mashtips is backed aside its audience. As an Amazon Associate I earn from qualifying purchases.