In this article, you’ll learn how to convert your Google Sheets into PDF. PDFs are the perfect choice when you need to send a document to someone and don’t want it to be edited. They can be easily shared, printed, and viewed on most devices. Google Sheets makes it incredibly easy to convert your document into PDF, and there are several ways to do it. Each of the methods presented in this article is simple and efficient, so you can choose the one that suits your needs best.
Get your copy of the example workbook and let’s get started!
Saving Google Sheets as PDF using Download
This is the easiest way to convert your Google Sheets into PDF. You can download the PDF and then do whatever you want with it.
Follow these steps to convert your sheet into PDF:
- Go to the File menu.
- Select Download from the options.
- Choose PDF from the submenu.
This will open the print settings menu with the sheet ready to be exported as a PDF. If you’re satisfied with the current export settings, simply press the EXPORT button to download the file in PDF format.
In the export options, you can choose to export either the Current Sheet or the Entire Workbook. When you select the Workbook option, you’ll then get a Selection menu to choose which sheets to include.
This is ideal when you have multiple sheets that you want to include in the PDF.
The PDF file will download, and you’ll see a notification in your browser.
Saving Google Sheets as PDF using Print
Printing the file is another option because you can print the workbook as a PDF! The term “print to PDF” may sound strange, but it’s simply a way to save the file in PDF format.
Click on the Print icon in the toolbar to open the Print Settings menu. You can also use the keyboard shortcut Ctrl + P.
This will open the print settings menu. Adjust the necessary settings and then press the NEXT button.
This is the same menu as when downloading the file in PDF format, so you can also select which sheets you want to save in the PDF.
Now, you can select the Destination for printing. In this case, select Save as PDF and then click the Save button.
This will open a file selection menu where you can choose the location and name of the PDF file to save to your hard drive.
💡 Tip: Invoices and other documents will look better if you print them without the gridlines.
Saving Google Sheets as PDF using Send a copy
When you need to create a PDF version of the file, chances are you also need to send it to someone. You can accomplish both tasks in a single action by using the Send a copy feature. This allows you to send the current file via email, and you can choose the file format.
Follow these steps to send your workbook via email in PDF format:
- Go to the File menu.
- Select Send from the options.
- Choose Send a copy from the submenu.
This will open a pop-up window where you can compose an email.
- You can choose to Send yourself a copy for archival purposes.
- Add any recipients you want to send the email to.
- Add a subject to your email.
- Add the text of the message in the email.
- Choose the PDF file format from the options.
- Press the Send button.
This will send the PDF via email to your selected recipients from your Google account email address.
Conclusion
There are many reasons why you might need to save your Google Sheets file as a PDF. Fortunately, it’s quite easy to do! Google Sheets offers you several simple ways to convert your workbook into PDF. You can download it as a PDF, send it by email as a PDF, or print it as a PDF. These methods will all preserve the appearance of your document while making it easy to share and view. Have you ever needed to convert your Google Sheets files to PDF? Do you use any of these methods? Let me know in the comments section below!
Find all the tips for Google Sheets at Crawlan.com.
