How to print 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.

Browse more tutorials
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...
The First Thing I Do When Starting a Google Sheet

The First Thing I Do When Starting a Google Sheet

Are you tired of the default look of your Google Sheets? In this video, ...
Convert Google Sheets into a REST API

Convert Google Sheets into a REST API

How to use Google Sheets as a database by turning it into a REST API wit...
Scrape Google Maps

Scrape Google Maps

Scrape any query in Google Maps into your Google Sheets. Enter your API ...
5 Ways To Use Google Sheets for Advanced Project Management

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Man...
How To Export Your Beautiful Sheets to PDF

How To Export Your Beautiful Sheets to PDF

Want to create sleek, stunning PDFs from your Google Sheets? Look no fur...

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

No exact channel match cached for “How to print Google Sheets” yet. Search Better Sheets on YouTube.

Terms and formulas behind this

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

Related questions

How to 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 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 →

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 →

Google Sheets how to set print area

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 →

What are pivot tables in Google Sheets

Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.

Get the answer →

Need more than a quick answer?

Membership unlocks 636+ tutorials, unlimited generators, and every template.