How to Export Google Sheets as PDF: Complete Settings Guide

Google Sheets is a powerful tool for managing data, building reports, and handling financial calculations. When it comes to sharing your work in a clean, professional format, exporting to PDF is often the best choice. PDF locks your layout and prevents recipients from accidentally editing your data. This guide walks you through every important setting in Google Sheets’ PDF export dialog so you can produce polished, correctly formatted documents every time.

Basic Export Steps

1. Open your Google Sheets spreadsheet.
2. Click File in the top menu bar.
3. Hover over Download.
4. Select PDF Document (.pdf).
5. A PDF export settings dialog will open where you can configure all output options.
6. Once you have configured your settings, click the Export button in the top right corner to download.

Print Range Settings: Export Only What You Need

Google Sheets gives you precise control over which content to include in the exported PDF. In the settings dialog, you can choose from:

• Current sheet: Exports only the currently active sheet (this is the default).
• Entire spreadsheet: Exports all sheets in the file, with each sheet starting on a new page.
• Selected cells: If you select a specific cell range before opening the export dialog, only that range will be included in the PDF.

If you only need a portion of your data, select the relevant cell range before opening the export settings. This prevents unwanted blank pages or extra content from appearing in your PDF.

Scaling Options: Fitting Content on the Page

Spreadsheet content is prone to being cut off in PDF exports. The scaling setting is your primary tool for preventing this:

• Normal (100%): Exports at the original scale — works best when you have already manually set column widths.
• Fit to width: Automatically scales content so that all columns fit within a single page width. This is one of the most commonly used options.
• Fit to height: Scales content so all rows fit within a single page height.
• Fit to page: Scales both dimensions to fit all content onto a single page — best suited for small spreadsheets.
• Custom number: Enter a specific percentage to scale manually.

For wide tables with many columns, try “Fit to width” combined with landscape orientation to prevent columns from being cut off.

Landscape Orientation Settings

When your spreadsheet has many columns, landscape orientation often produces a much better PDF than portrait:

1. In the export dialog, locate the Orientation setting.
2. Select Landscape.
3. Combine this with the Fit to width scaling option for best results.

If your spreadsheet has a very large number of columns (more than ten), consider hiding non-essential columns or splitting the data into smaller tables before exporting.

Showing or Hiding Gridlines

By default, Google Sheets may not display cell gridlines in the exported PDF. To control gridline visibility, find the Formatting section in the export dialog and toggle the Show gridlines option. If you have already applied custom border styles to your table, it is usually best to turn off gridlines to avoid visual overlap between your custom borders and the default grid.

Exporting Multiple Sheets

If your spreadsheet contains multiple sheets, selecting “Entire spreadsheet” in the export settings will compile all sheets into a single PDF file, with each sheet beginning on a new page. Keep in mind that hidden sheets are still included in the export. If you do not want certain sheets to appear in the PDF, you will need to either delete or temporarily move them before exporting.

Fixing Common Formatting Issues

• Content being cut off: Switch to “Fit to width” or “Fit to page” scaling, and make sure margins are not set too narrow.
• Incorrect date or number formats: Double-check that cell formats are set correctly in Google Sheets before exporting.
• Font rendering issues: Standard Google Sheets fonts embed correctly, but unusual fonts may be substituted in the exported PDF.
• Charts being clipped: Make sure your charts are sized to fit within the print area boundaries before exporting.
• Unwanted blank pages: Reduce margins or use a selected cell range to exclude empty rows and columns from the export.

Advanced Tips: Frozen Rows as Headers and Page Elements

The PDF export dialog also offers useful advanced options:

• Repeat frozen rows as headers: If your spreadsheet has frozen header rows, you can choose to repeat them at the top of every page in the PDF, making multi-page reports much easier to read.
• Headers and footers: Add document titles, page numbers, dates, or other information to the top or bottom of each page.

Taking a moment to configure these settings before exporting can make a significant difference in the professionalism and readability of your final PDF report.

Do it in your browser — the file never leaves your device: PDF Tools