On this page
Choose sheets and print areas deliberately
Exclude hidden working sheets, raw imports and helper ranges unless recipients need them. A print area prevents distant formatting or accidental cells from creating extra pages.
Review every selected sheet’s used range. Meaningful content can sit far beyond the first visible screen.
Fit-to-page can solve width and harm readability
Fit width helps wide tables, but fitting an entire large sheet to one page can make text unreadable. One page wide and several pages tall is often safer.
Use landscape for wide data and portrait for narrow summaries. The live preview should expose clipping, scaling and page breaks before conversion.
Margins, gridlines and repeating headers
Margins need room for printing and headers. Gridlines can help dense tables but distract on dashboards. Repeating header rows preserve context across pages.
Check that titles, dates and page numbers do not collide with content, and inspect merged cells, charts and manual page breaks in the actual PDF.
| Problem | Adjustment |
|---|---|
| Columns clipped | Landscape or fit width |
| Text too small | Reduce range or add pages |
| Blank pages | Check used range and print area |
| Lost context | Repeat header rows |
Verify the generated PDF
Inspect the first and last page of every sheet, page breaks around totals, chart labels and confidential hidden content. Formulas become rendered values rather than editable calculations.
Keep the workbook as the editable source. The PDF is a fixed presentation copy, not a reversible replacement for spreadsheet structure.
Put the workflow into practice
Arrange source documents, select the pages you need, and create one PDF locally in your browser. Review the result before choosing any optional next step.
Try Excel to PDFFrequently asked questions
Clear answers before you merge
How do I stop columns being cut off?
Set a print area, orientation and fit-width policy, then inspect the preview.
Should I fit the entire sheet to one page?
Only if the result stays readable; one page wide is often safer.
Are formulas preserved?
The PDF shows rendered values, not editable formulas.
Can sheets need different settings?
Yes. Review per-sheet dimensions and content.
