Export Google Sheets as PDF in Landscape
Exporting a Google Sheet in landscape orientation is the most reliable fix for wide spreadsheets that get cut off in portrait mode. Set the orientation in the page setup and the export will use it.
Set landscape orientation before exporting
Go to File > Page Setup in Google Sheets. Under 'Orientation', select 'Landscape'. Click OK to save the setting. Now when you click the Docs to PDF extension icon, the PDF is generated in landscape orientation.
Landscape plus fit-to-page for wide sheets
For very wide spreadsheets, combine landscape orientation with the 'Fit to page width' scaling option. Both settings are in File > Page Setup. This combination ensures that all columns fit on the page while using the full width of the landscape layout.
Landscape for specific tabs only
Page setup in Google Sheets applies to the entire workbook. If you need some tabs in landscape and others in portrait, export them separately and combine the PDFs afterward using a PDF editor.
Frequently Asked Questions
How do I export a Google Sheet in landscape mode?
Go to File > Page Setup, select 'Landscape', click OK, then export with the Docs to PDF extension.
Why are my columns still cut off after setting landscape?
The spreadsheet may have too many columns to fit even in landscape mode. Add 'Fit to page width' scaling in File > Page Setup to compress all columns onto one page width.
Related article
Convert Google Docs to PDF in Landscape →Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Install Free Extension