Excel doesn’t convert “the spreadsheet” to PDF — it converts whatever the file’s print settings say to print, sheet by sheet. Those settings were often set (or never set) for an entirely different purpose than the PDF you’re trying to produce now, which is why the output rarely matches what you see on screen.
Only one sheet came through
If a workbook has five tabs and the PDF only has one, check whether a print area was ever defined on this file. Once someone sets Page Layout → Print Area → Set Print Area on a sheet — even years ago, for a one-off print job — Excel remembers it as that sheet’s default print scope, and every future export, including to PDF, only includes that defined region unless it’s explicitly cleared. A sheet with no print area set exports in full; a sheet with a lingering print area from an old task exports only that slice.
Fix: on each sheet, Page Layout → Print Area → Clear Print Area, then re-export.
Only the active sheet converted, not the whole workbook
Selecting File → Print and converting from there only sends the sheet you’re currently looking at, not the whole workbook, unless you explicitly select multiple tabs first (click the first tab, then shift-click the last one, or ctrl-click specific tabs) before printing. This trips people up because it’s easy to assume “convert to PDF” always means “the whole file.”
Excel to PDF sidesteps this uncertainty: upload the workbook and every sheet is included in the output PDF automatically, in tab order, without needing to select anything first.
Dozens of near-blank pages appeared
The opposite problem — a workbook that should be two pages exports as fifteen, most nearly empty — usually means Excel’s print range detected more used space than actually has content. A cell formatted once and later cleared, or a stray character typed far outside the visible data and deleted, still counts as “used” as far as the print range is concerned, so Excel includes blank pages out to wherever that phantom cell was.
Fix: select the actual range with data, Ctrl+End to find where Excel currently thinks the used range ends (if it lands somewhere far past your real data, that’s the culprit), then set an explicit print area covering just what you need before converting.
Columns or rows cut off at the page edge
This is a different, more common problem with its own dedicated fix — see How to Convert Excel to PDF for the fit-to-page settings that solve it, and how our converter handles it automatically.
The reliable way to check before sending
Before relying on any exported PDF, open it and count: does the page count match what you expect, and does every tab you meant to include actually appear? A thirty-second check catches a missing sheet before it becomes a client’s problem instead of yours.
After converting
- Compress the PDF if the export came out unexpectedly large from those phantom blank pages
- Delete any stray blank pages that still made it through despite clearing the print area
- Merge it with other documents once the sheet content is right
Ready? Try the free Excel to PDF tool now — no sign-up, no watermark, and your file is never stored.