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.

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 Add Columns in Google Sheets

How To Add Columns in Google Sheets

Do you know all the ways to add columns to your Google Sheets?
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...
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...

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

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