Export Google Sheets as PDF Fit to Page
Fit to page scaling is the most common print setting change before exporting a Google Sheet as PDF. It ensures that all columns and rows fit within the page boundaries without being cut off.
Where to find the scaling options
Go to File > Page Setup in Google Sheets. The scaling section offers several options: Normal (100%), Fit to page, Fit to page width, and Fit to page height. 'Fit to page' is the most aggressive option and may make text very small on large spreadsheets. 'Fit to page width' is usually the better choice for wide sheets.
Fit to page width vs. fit to page
'Fit to page width' compresses the horizontal axis so all columns fit, but lets the sheet extend vertically across as many pages as needed. 'Fit to page' compresses both axes to fit everything on a single page. Use 'fit to page width' for reports with many rows and 'fit to page' for dashboards that should appear on one page.
Checking the result in print preview
Before running the extension, open File > Print to see a preview of how the sheet will look. If the text is too small or the layout looks compressed, adjust the scaling or margins. Close the print dialog without printing, then click the extension icon to export.
Frequently Asked Questions
How do I make my Google Sheet fit on one page in the PDF?
Go to File > Page Setup, set scaling to 'Fit to page', click OK, then export.
Can I fit only the width without compressing vertically?
Yes. Use 'Fit to page width' instead of 'Fit to page'. This scales horizontally but lets the content span multiple pages vertically.
Related article
Export Google Docs to PDF without losing formatting →Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Install Free Extension