You export a spreadsheet to PDF and it splits across four pages — the right two columns on page 2, the bottom rows on page 3, lonely cells on page 4. Same result every time. The fix is in Excel, not the converter.
It's Excel's print setup, not the converter
Most converters honour Excel's page setup. If the spreadsheet would print across four pages, the PDF will too. The trick is configuring the page setup before converting.
Fit to one page in Page Layout
In Excel: Page Layout tab > Scale to Fit > Width: 1 page, Height: 1 page. Excel calculates the scaling needed to fit everything on one sheet. Now print preview shows the whole spreadsheet on one page.
Then convert to PDF. The PDF reflects the new settings.
When it's too small to read
Fit-to-one-page on a 50-column spreadsheet shrinks text to unreadable. Two strategies. First, fit to width only — Page Layout > Scale to Fit > Width: 1 page, Height: blank. Excel scales horizontally and lets rows flow onto extra pages. Second, switch to landscape — Page Layout > Orientation > Landscape. More horizontal room, fewer column splits.
For very wide sheets, the right answer is often "convert page-by-page" — accept multiple pages and use page breaks deliberately.
Print area and page breaks
If you only want part of the sheet in the PDF, set a Print Area: select cells > Page Layout > Print Area > Set Print Area. The PDF includes only those cells.
For manual page breaks (e.g. "page 1 should end at row 50"), use View > Page Break Preview and drag the page boundaries to where you want them.
FAQ
Why does Excel default to multi-page?
Default scaling is 100% — Excel doesn't know your sheet's intended size. Set scaling before converting.
Should I use landscape?
If your sheet is wider than tall, yes. Landscape often solves multi-page splits without aggressive scaling.
Will text become unreadable?
It can if you force-fit a huge sheet. Use Fit to Width only and let height flow naturally.
What about charts?
Charts respect Excel's print area. Place them where you want them in the print preview before converting.
Page Layout > Scale to Fit, then convert. Convert your Excel to PDF cleanly.