How to Select Print Area on Google Sheets (PC or Mac)

This wikiHow teaches you how to print specific cells on Google Sheets using a computer.

Steps

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/55/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg/ v4-728px-Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 5/55/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg/v4-728px-Set-Print-Area-on-Google-Sheets-on-PC- or-Mac-Step-1.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser-output “></div>”}

Go to https://sheets.google.com in any web browser. If you are not signed in to your Google account, proceed to sign in now.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/76/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg/ v4-728px-Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 7/76/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg/v4-728px-Set-Print-Area-on-Google-Sheets-on-PC- or-Mac-Step-2.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output “></div>”}

Click the sheet that you want to print.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/67/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg/ v4-728px-Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 6/67/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg/v4-728px-Set-Print-Area-on-Google-Sheets-on-PC- or-Mac-Step-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output “></div>”}

Select the cell that you want to print. Click a cell and drag to select the remaining cells.

To select multiple rows, click and drag your mouse over the row number on the left side of the screen.
To select multiple columns, click and drag your mouse over the column name letter at the top of the screen.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c2/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg/ v4-728px-Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ c/c2/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg/v4-728px-Set-Print-Area-on-Google-Sheets-on-PC- or-Mac-Step-4.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output “></div>”}

Click the print icon located near the upper left corner of the screen. The print menu will appear.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/30/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg/ v4-728px-Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 3/30/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg/v4-728px-Set-Print-Area-on-Google-Sheets-on-PC- or-Mac-Step-5.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:550,”licensing”:”<div class=”mw-parser-output “></div>”}

Select Selected Cells from the “Print” drop-down menu. This option is at the top of the Print menu.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4c/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg/ v4-728px-Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 4/4c/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg/v4-728px-Set-Print-Area-on-Google-Sheets-on-PC- or-Mac-Step-6.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:550,”licensing”:”<div class=”mw-parser-output “></div>”}

Click Next in the upper right corner of the screen. The print dialog will open with a different interface depending on the computer.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b3/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg/ v4-728px-Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ b/b3/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg/v4-728px-Set-Print-Area-on-Google-Sheets-on-PC- or-Mac-Step-7.jpg”,”smallWidth”:460,”smallHeight”:341,”bigWidth”:728,”bigHeight”:539,”licensing”:”<div class=”mw-parser-output “></div>”}

Click Print . The document with only cells selected will start printing.

You may need to select a printer before printing.

Steps

Related Posts