How to Convert Excel to PDF
Converting Excel to PDF seems trivial until the output comes out as fifteen pages of awkwardly split columns instead of the clean one-page summary you expected.
Why Excel-to-PDF often looks wrong
Excel's print area and page layout settings, not just your data, determine what ends up in the PDF. If you never set a print area, Excel will try to print every cell with data in it, often splitting wide tables across several pages in a way that makes them hard to read.
Setting the print area first
Before converting, select just the cells you actually want in the PDF and set them as the print area under the Page Layout tab. This alone fixes the majority of messy Excel-to-PDF conversions, since it stops Excel from guessing what you wanted included.
Fitting everything on one page
Use the 'Scale to Fit' option under Page Layout to shrink wide tables down to fit the page width, rather than letting Excel split columns across multiple pages. This is especially useful for wide data tables that are only a few rows tall.
Orientation matters more than people expect
A wide table almost always converts more cleanly in landscape orientation than portrait, since it gives Excel more horizontal room before it needs to split columns onto a second page. Switch to landscape before converting if your data is wider than it is tall.
Checking gridlines and headers
By default, Excel may not print gridlines or row/column headers, which is usually what you want for a clean, presentable PDF, but double-check the print preview beforehand if you specifically need those references visible in the final document.
