How to set a print area in Google Sheets, so you can print selected cells or sheets

Woman using Apple Mac laptop over colorful background

You can change the print area of Sheets in one of two ways — by printing only certain cells, or by changing the layout on the page. 

Here’s how to do both.

How to print selected cells in Google Sheets

1. Open the Sheets document you wish to print.

How to set print area in Google Sheets

2. Highlight the cells you want to print.

How to set print area in Google Sheets

3. Hit Ctrl + P on a PC, or Command + P on a Mac, or go to File, then select Print at the very bottom of the list. 

4. In Print options, choose “selected cells.”

How to set print area in Google Sheets

5. This will only print the highlighted region of the current sheet. Highlighting cells across sheets will not group them together.

How to change the print layout in Google Sheets

1. You can use the same option as above to choose to print only one sheet, or all sheets in the document. To print all sheets in a document, select “workbook” from the print options.

How to set print area in Google Sheets
2. If you’re having trouble printing on one page, then you can adjust the Margins to “Narrow,” or select “Fit to page” under scale.

If that doesn’t work, then you can adjust the scale more precisely by setting Scale to “Custom number” and entering the preferred scale as a percentage number. Larger numbers make the sheet or cell bigger on the page and smaller numbers take up less space on the page.

How to set print area in Google Sheets

Related coverage from How To Do Everything: Tech:

SEE ALSO: The best Google Assistant smart speakers you can buy

Join the conversation about this story »

NOW WATCH: The Navy has its own Area 51 and it’s right in the middle of the Bahamas

How to set a print area in Google Sheets, so you can print selected cells or sheets

LEAVE A REPLY

Please enter your comment!
Please enter your name here