In this article, we’re going to reveal the simplest way to convert any Google Sheets spreadsheet into a PDF format with just a few clicks. Follow the step-by-step instructions below and you’ll be saving your sheets as PDFs in no time!
Save and Export to PDF in Google Sheets
Let’s dive right into the process of saving a Google Sheet as a PDF.
1. From the file menu, select « File » followed by « Download ». From the side menu, choose « PDF (.pdf) ».
In the top file menu, click on « File » which will display a menu. Hover over or click on « Download » to reveal a pop-up menu on the side. From this side menu, select « PDF (.pdf) ».
2. Configure the Export Selection and Layout Options
Once you’ve selected the PDF format, a print settings display will open. On the left-hand side, you’ll see a preview of your content, and on the right, you’ll find the print settings menu.
The print settings offer various configurations:
- Export: This drop-down menu allows you to choose what content you want to export into the PDF. You can select the current sheet, specific cells, or the entire workbook if you have multiple sheets.
- Paper Size: Here, you can set the size of the PDF area. The default selection is A4, but there are also other sizes available, including the option to specify a custom size.
- Page Orientation: This option can be changed to best suit your content or requirements.
- Scale: You can choose to scale the content to fit the page by width, height, or full page. Additionally, you can use the default scaling of 100% or set a custom scale.
- Margins: This option allows you to change the margins to normal, narrow, or wide.
- Set Custom Page Breaks: If needed, you can add additional page breaks to your content, splitting it across multiple PDF pages.
3. Set the Formatting Options
Expand the section labeled « Formatting » in the print settings by clicking the arrow next to the label. In this section, you can specify the following options:
- Show Gridlines: Check or uncheck this box to show or hide the gridlines in your PDF.
- Show Notes: You can choose whether to show or hide any notes on your sheet in the PDF by using the checkbox.
- Page Order: This option allows you to control the page order displayed in multi-sheet documents.
- Alignment: The two drop-down menus enable you to choose the position of the content on the page. You can set both horizontal and vertical alignments.
- Headers and Footers: Select the applicable checkboxes to display additional data in the header and footer areas of your PDF.
4. Click « Export » to Generate Your PDF and Download the File
Once you’ve made all the desired configurations, simply click on the blue « Export » button located at the top right-hand side of the display.
Google Sheets will then return to the main screen, and your PDF file will be downloaded. You’ll receive a notification in the bottom left-hand corner of your screen. The PDF will be stored in the default downloads directory of your computer. Alternatively, you can directly click on the downloaded file at the bottom of your display to open it.
That’s it! With these simple steps, you can easily convert your Google Sheets into PDF files. We hope this article has been helpful and has provided you with a better understanding of how to save Google Sheets as PDFs. For more useful tips and tricks, visit Crawlan.com. Stay tuned for more exciting articles on optimizing your workflow and enhancing your productivity!
