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.

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 ...
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...
Highlight Row as You Move Your Cell Selection

Highlight Row as You Move Your Cell Selection

Checking data? This script changes bg color of entire row as you move yo...
Export Your Google Sheets to PDF with a URL

Export Your Google Sheets to PDF with a URL

I want to show you a fantastic new tool that I created called bettershee...
How to Insert Multiple Rows in Google Sheets (Easy to Hard)

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

Learn how to add multiple rows to your google sheets by hand, and automa...

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 only 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 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 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.

Get the answer →

How to set print area 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 print range 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