How to print certain cells in Google Sheets

Open File → Print (or Ctrl/Cmd+P). Set current sheet vs workbook, paper size, margins, and scale (fit to width is common). Set a custom range under Print → Selection if you only want part of the grid. Use View → Freeze and page breaks carefully; print layout is controlled in the print sidebar.

Steps

  1. 1

    Select the range if you only need part of the sheet.

  2. 2

    File → Print.

  3. 3

    Choose sheet, size, margins, and scale.

  4. 4

    Set orientation and page breaks, then print or save as PDF.

Related tutorials

These videos might help you go deeper on this topic.

Watch more tutorials
How To Get Someone to look at a Cell in Your Sheet

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in ...
Whitening Google Sheet Prank

Whitening Google Sheet Prank

Drive your office crazy by setting a trigger to lighten the text and bac...
How to Merge Cells in Google Sheets

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge mu...
Google Sheet Basics - The Absolute Basics

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Related blog posts

Written guides that go deeper on this question.

Browse the blog

Better Sheets on YouTube

Watch matching videos from youtube.com/bettersheets.

Search channel

Terms and formulas behind this

Want the full definition or how a formula works? Start here.

Related questions

How to print certain columns in Google Sheets

Open File → Print (or Ctrl/Cmd+P). Set current sheet vs workbook, paper size, margins, and scale (fit to width is common). Set a custom range under Print → Selection if you only want part of the grid. Use View → Freeze and page breaks carefully; print layout is controlled in the print sidebar.

Get the answer →

How to print specific cells in Google Sheets

Open File → Print (or Ctrl/Cmd+P). Set current sheet vs workbook, paper size, margins, and scale (fit to width is common). Set a custom range under Print → Selection if you only want part of the grid. Use View → Freeze and page breaks carefully; print layout is controlled in the print sidebar.

Get the answer →

How to print selected cells in Google Sheets

Open File → Print (or Ctrl/Cmd+P). Set current sheet vs workbook, paper size, margins, and scale (fit to width is common). Set a custom range under Print → Selection if you only want part of the grid. Use View → Freeze and page breaks carefully; print layout is controlled in the print sidebar.

Get the answer →

How do i set print area in Google Sheets

Open File → Print (or Ctrl/Cmd+P). Set current sheet vs workbook, paper size, margins, and scale (fit to width is common). Set a custom range under Print → Selection if you only want part of the grid. Use View → Freeze and page breaks carefully; print layout is controlled in the print sidebar.

Get the answer →

How to set the print area in Google Sheets

Open File → Print (or Ctrl/Cmd+P). Set current sheet vs workbook, paper size, margins, and scale (fit to width is common). Set a custom range under Print → Selection if you only want part of the grid. Use View → Freeze and page breaks carefully; print layout is controlled in the print sidebar.

Get the answer →
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Get it free