Merge Google Sheets Preserving Layout
Spreadsheet layout in a merged PDF depends on the print settings configured in each source Sheet. Getting those settings right before merging means the combined PDF looks exactly like each Sheet was designed to print.
Configure print settings before merging
In each Sheet, go to File > Print and configure the print area, page orientation, scaling, and margins. Set columns to fit on one page if you want all data visible. These settings are stored in the Sheet and applied automatically when the extension exports it.
Row and column freezes do not affect PDF
Frozen rows and columns are a screen-view feature. They do not affect how the data appears in a PDF export. Every row and column in the print area appears at the configured size.
Frequently Asked Questions
Why do some columns get cut off in the merged PDF?
Columns are cut off when the print area or scaling is not set to fit the page. Open the source Sheet, go to File > Print, enable 'Fit to page' scaling, and re-export.
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