Question 1

How to convert an Excel spreadsheet to PDF that actually fits

Accepted Answer

Set a print area, then use Page Layout → Scale to Fit with Width set to 1 page and Height left on Automatic. Add repeating header rows through Print Titles, switch to landscape for wide tables, and export with File → Export → Create PDF/XPS. Never set both Width and Height to 1 page.

Question 2

How to fit more on a printed page without making it unreadable

Accepted Answer

Cut the margins first, since it is free: moving from one inch to half an inch adds about 28 percent more text area on A4. Then drop the scale to 90 or 80 percent, and only then consider two pages per sheet. Keep body text at 9pt or larger for anything you will read continuously.

Excel to PDF

Guides that use this tool