iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
This Itechguide teaches you how to set print area in Google Sheets. This is helpful if you want to print specific cells in Google Sheets.
Step 1: Open the Google Sheets Document
- Open Sheets.Google.com. Then login with your Google Account.
- You have two options to open your Google Sheets document. You can either open it from the list of recent documents – labelled Today, Previous 30 days, etc.

- Alternatively, you could open the document from Google Drive. To access Google Drive, click the 3 lines left of Google Sheets home page. Then select Drive.


Once you have opened your document, proceed to the next step…
Step 2: Select Cells to Set Print Area
Once the document is opened, the next step is to select the Google Sheets cells you want to include in a print area. Here are the steps…
Free tools Windows power users keep installed
One-click scans. No signup required.
- Click on the first cell you want to be in the print area. In this example, cell A1.

- Then press the Shift key on your keyboard.

- Finally, click the last cell you want to be in the print area. In this example, cell C15.

- All the cells you want in your print area will now be selected.

Step 3: Open Print Settings and Set Print Area
- With the cells you want in your print area selected, on the top left of Google Sheets, click the print icon. This will open Print Settings.

- Then, to set print area in Google Sheets, on the top right of Print Settings, click the Print drop-down and select Selected cells…(default is Current Sheet).


- Finally, on the top right of Print Settings (above Print drop-down), click Next.

- You can then select the printer to print to and click Print. Only the selected area of the Google Sheets document will be printed!

It is this easy to set print area in Google Sheets! I hope you found this Itechguide helpful and easy to follow. If it did, click on “Yes” beside the “Was this page helpful” question below.
Popular on Amazon
- 1 ream (500 sheets) of 8.5 x 11 white copier and printer paper for home or office use
- Multipurpose letter size copy paper works with laser/inkjet printers, copiers and fax machines
- Smooth 20lb weight paper for consistent ink and toner distribution; dries quickly and resists paper jams
- Bright white paper (92 GE; 104 Euro) offers great contrast for crisp printing and vivid color
- Virgin copy paper providing professional quality results; acid-free to prevent yellowing
You may also express your thoughts and opinions by using the “Leave a Comment” form at the bottom of this page.
Finally, if you enjoyed this guide and want more Google guides, visit our Google How To page.
Quick Recap
Also popular on Amazon
- 8 ream case (4,000 sheets) of 8.5 x 11 white copier and printer paper for home or office use
- Multipurpose letter size copy paper works with laser/inkjet printers, copiers and fax machines
- Smooth 20lb weight paper for consistent ink and toner distribution; dries quickly and resists paper jams
- Bright white paper (92 GE; 104 Euro) offers great contrast for crisp printing and vivid color
- Virgin copy paper providing professional quality results; acid-free to prevent yellowing
Also popular on Amazon
- 5 ream case (2,500 sheets) of 8.5 x 11 white copier and printer paper for home or office use
- Multipurpose letter size copy paper works with laser/inkjet printers, copiers and fax machines
- Smooth 20lb weight paper for consistent ink and toner distribution; dries quickly and resists paper jams
- Bright white paper (92 GE; 104 Euro) offers great contrast for crisp printing and vivid color
- Virgin copy paper providing professional quality results; acid-free to prevent yellowing
Also popular on Amazon
- 3 ream case (1,500 sheets) of 8.5 x 11 white copier and printer paper for home or office use
- Multipurpose letter size copy paper works with laser/inkjet printers, copiers and fax machines
- Smooth 20lb weight paper for consistent ink and toner distribution; dries quickly and resists paper jams
- Bright white paper (92 GE; 104 Euro) offers great contrast for crisp printing and vivid color
- Virgin copy paper providing professional quality results; acid-free to prevent yellowing
Also popular on Amazon
- HP Papers is sourced from renewable forest resources and has achieved production with 0% deforestation in North America. Each ream is wrapped in a polyurethane coated paper wrapper to protect the cut sheets from moisture damage
- Sheet size – 8.5 x 11; Thickness – 20 pounds; Brightness – 92 bright white
- HP Copy&Print20 20 pounds printer paper is Forest Stewardship Council (FSC) certified and contributes toward satisfying credit MR1 under LEED (Leadership in Energy and Environmental Design)
- All HP Papers provide premium performance on HP equipment, as well as on all other printer and copier equipment; 100% satisfaction guaranteed; ColorLok technology provides more vivid colors, bolder blacks and faster drying
- Superior quality, reliability, and dependability for high-volume printing at home, at school and in the office; HP Copy&Print20 print and copy paper prevents yellowing over time to ensure a long-lasting appearance for added archival quality

