How To Set Print Area In Google Sheets

Google Sheets is a powerful, web-based spreadsheet tool that lets you create and format spreadsheets and simultaneously work with other people. One of the useful features it offers is the ability to set a specific print area. This feature is especially handy when you only need to print specific parts of the spreadsheet and not the entire document. In this post, we’ll guide you on how to set the print area in Google Sheets.

Step by Step Guide

Step 1: Open your Google Sheet

First, you need to open the Google Sheet that contains the data you want to print. You can do this by navigating to Google Drive, locating your sheet, and clicking to open it.

Step 2: Select the area to print

Next, highlight the cells that you want to include in the print area. You can do this by clicking and dragging your mouse over the cells. Keep in mind that you can select multiple areas by holding down the Ctrl key (for Windows) or the Cmd key (for Mac) while selecting.

Step 3: Open the print settings

Now that you have selected the area you want to print, go to the top menu and click on File then Print (or use the shortcut Ctrl + P for Windows or Cmd + P for Mac).

Step 4: Set the print range

In the Print settings dialog box, under the “Print Range” section, select the “Selected cells” option. This action will ensure that only the cells you highlighted in Step 2 will be included in the print out.

File > Print > Print Range > Selected cells

Step 5: Print your document

Finally, click on the “Next” button at the top-right corner of the dialog box. This action will open a new window or tab where you can finalize your print settings. Click on “Print” to start printing your selected cells.


Setting a print area in Google Sheets is straightforward and easy. This feature allows you to include only the necessary data in your print-outs, saving you time, paper, and ink. It’s another example of how Google Sheets can make your work more efficient and environmentally friendly.