How to Convert Excel to PDF

Converting Excel to PDF seems trivial until you get fifteen pages of oddly split columns instead of the clean one-pager you expected.

Why it goes wrong

Excel's print area and page layout settings — not your data — decide what ends up in the PDF. Never set a print area? Excel tries to print everything with data in it, often splitting wide tables across pages awkwardly.

Set the print area first

Select only the cells you want, set them as the print area under Page Layout. This one step fixes most messy Excel-to-PDF conversions by stopping Excel from guessing.

Fitting it all on one page

Use 'Scale to Fit' under Page Layout to shrink wide tables down instead of letting Excel split columns across pages. Especially useful for wide tables that aren't tall.

Orientation matters more than you'd think

A wide table almost always converts cleaner in landscape than portrait — more horizontal room before Excel needs to split columns onto a second page.

Gridlines and headers

Excel often skips printing gridlines and row/column headers by default, which is usually what you want for a clean PDF — but check the print preview if you specifically need them visible.