Convert Google Sheets to PDF Fit to Page
Fit to page scaling ensures all your data lands on the page without columns or rows being cut off at the edge. It is the most common print setting used with Google Sheets exports.
Enabling fit to page in print settings
Go to File > Print in Google Sheets. In the Scale section, choose one of the fit options: Fit to width, Fit to height, or Fit to page. Fit to page shrinks the content proportionally so everything lands on one page. Fit to width scales so all columns fit and adds pages vertically as needed.
Choosing the right scale option
Use Fit to page when your data is compact and you want a single-page output. Use Fit to width for data tables that have many columns but where adding more vertical pages is acceptable. Avoid over-scaling large datasets, as text can become too small to read comfortably.
Setting print areas to control scope
If you only want a portion of the sheet in the PDF, define a print area in Google Sheets by selecting the cells you want and going to View > More options > Set print area. The extension exports only the print area when this is defined.
Frequently Asked Questions
How do I make my Google Sheets fit on one PDF page?
Go to File > Print, set the scale to Fit to page, and then export using the Docs to PDF extension.
Can I scale just the width and let the height flow across multiple pages?
Yes. Set the scale to Fit to width in the print settings. All columns will fit on one page width and the rows will flow onto additional pages as needed.
Related article
Convert Google Docs to PDF & Preserve Formatting →Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Install Free Extension