In this tutorial, you will learn how to save Google Sheets as pdf.
There are a number of reasons to save Google Sheets as a PDF. For example, saving your spreadsheet as a PDF allows you to send the data to clients and customers in a professional format, and creates a snapshot of data in a Google Sheet at a given time
It takes just a few clicks to save Google Sheets as a PDF. Read on to learn how
Saving as PDF
Quick Navigation
Here are the steps to follow to save a Google Sheet as a PDF in just a few clicks
Step 1
In the spreadsheet you want to save as PDF, open the File menu and hover over the Download submenu to expand it. Then choose PDF Document (.PDF)
Step 2
In the PDF Print Settings, click the blue Export button in the upper-right corner
Step 3
The PDF file will be saved to your harddrive according to your browser file saving settings
PDF Export Options
If the PDF you downloaded following the above steps doesn’t look quite how you’d hoped, follow the steps below to adjust margins, gridlines and other export options
Step 1
Follow Step 1 above to open the PDF Print Settings, but don’t click Export yet
Step 2
In the settings sidebar, update page layout, scaling and margins options as needed. The preview will adjust as you make each change
Step 3
To hide gridlines from the PDF, click on the Formatting section to expand it, then uncheck the box next to Show Gridlines
Step 4
Under the Headers & Footers section, you can turn on page numbers, Sheet name or other options as needed
Step 5
Once you’re happy with how the PDF Preview looks, click the blue Export button to save the spreadsheet as a PDF
Summary
Example Spreadsheet: Make a copy of the example spreadsheet, and .pdf example
In this tutorial, I covered how to save Google Sheets as pdf. Want more? Check out all the Google Sheets Tutorials.