How to make Google Sheets landscape

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
Turn Bland Sheets Into Glam Sheets!

Turn Bland Sheets Into Glam Sheets!

A few tips to make your Google Sheets look better.
Better Google Ad Writing Tool Sheet Makeover

Better Google Ad Writing Tool Sheet Makeover

Got an amazing tool from Inside Google Ads course by Jyll. She shares th...
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...
Google Sheets Easter Eggs Beyond PRIDE

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks th...
Big Year - a Whole Year in One Google Sheets Tab

Big Year - a Whole Year in One Google Sheets Tab

Get "Big Year" for free via Gumroad. Get perspective on your 2024 plan ...
How to make a Pill Form Field in Google Sheets

How to make a Pill Form Field in Google Sheets

Create rounded pill form fields in Google Sheets. Using Canva and a bit ...

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 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 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 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 a 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 →