A spreadsheet is an infinite grid. A PDF has pages. Exporting one means deciding where to cut, and the default decides badly.
Why the default output is bad
Word and PowerPoint already know where their pages end. Excel does not — a sheet is a continuous grid, and the page breaks you see as dotted lines are calculated from the current paper size, not stored in the document.
So the exporter slices. Working left to right, it fits as many columns as the paper allows, then puts the rest on later pages. A 12-column table on A4 portrait becomes 8 columns on page 1 and 4 orphaned columns on page 2, with no row labels and no header to say what they are.
That output is not a bug. It is the only thing the exporter can do with a grid wider than the paper, absent instructions.
The three settings that fix it
| Setting | Where | Fixes |
|---|---|---|
| Fit to 1 page wide | Page Setup → Scaling | Orphaned columns |
| Repeat header rows | Page Layout → Print Titles | Pages with no column names |
| Set print area | Page Layout → Print Area | Stray cells adding blank pages |
| Landscape orientation | Page Setup | Wide tables, before scaling them down |
| Gridlines on | Page Setup → Sheet | Unreadable dense tables |
| Page order | Page Setup → Sheet | Down-then-over vs over-then-down |
"Fit to 1 page wide, and tall as needed" is the one to internalise. Setting both dimensions to one page crushes a long table into unreadable microtype; setting only the width keeps columns together and lets the rows run on as many pages as they need.
The blank pages
A near-universal complaint: a small table exports as four pages, three of them empty.
This happens because Excel remembers the used range, not what is visible. A cell that once contained a space, a stray format applied to a whole column, or a delete that cleared contents but not formatting all extend the used range far beyond the data.
Press Ctrl+End. If the cursor lands far beyond your table, that is the problem. Select every row and column between the data and that point, right-click, Delete — not Clear Contents, which leaves the formatting that caused it — then save and reopen. Setting an explicit print area also sidesteps it entirely.
Tables too wide to fit
Some tables are genuinely wider than any sensible paper, and the honest options are all trade-offs.
- Landscape plus scaling. Handles most cases. Below about 70% scaling the text becomes hard to read.
- A3 or Tabloid. Twice the area, if the recipient can print it or will read on screen.
- Split the columns deliberately. Export columns A–H as one section and A–B plus I–P as another, so the identifying columns repeat. Far better than the exporter's arbitrary cut, and Merge PDF joins the sections into one file.
- Hide what nobody needs. Working columns, intermediate calculations and notes rarely belong in the shared version.
That third option is the one people never think of and it produces by far the best result: every page carries the row identifiers, so no page is orphaned.
Fonts, size and the return trip
Two smaller things worth knowing.
Fonts. Excel does not embed fonts on export by default in several versions, so a spreadsheet using a corporate typeface can arrive substituted, which changes column widths and can push a column onto the next page. The setting and its consequences are in PDF font problems.
Size. Excel PDFs are usually small because they are mostly text and lines. If one is unexpectedly large, it is charts and conditional formatting being rendered as images rather than the data.
And going the other way — a PDF back into Excel — is a completely different problem with its own failure mode, because a PDF table has no cells. That is covered in how to get a PDF table into Excel accurately.
Frequently asked questions
Why does my Excel table split across pages?
Because a spreadsheet has no page boundaries — the exporter fits as many columns as the paper allows and puts the rest on later pages. Set Scaling to "Fit to 1 page wide" and leave the height as automatic, so columns stay together while rows run on.
Why does my PDF have blank pages?
Excel remembers the used range rather than what is visible, and a stray format or a cleared cell extends it well beyond your data. Press Ctrl+End to see where Excel thinks the sheet ends, delete the intervening rows and columns entirely, then save and reopen.
How do I repeat the header row on every page?
Page Layout, then Print Titles, then set "Rows to repeat at top". Without it every page after the first is a wall of numbers with nothing saying what the columns are — which is the most common complaint about exported spreadsheets.
Should I use Print to PDF or Save As PDF?
Save As or Export. Print to PDF goes through a print driver and loses hyperlinks and accessibility structure. Both honour the same page setup, so set the print area and scaling either way.
My table is too wide for any paper. What now?
Split the columns deliberately rather than letting the exporter cut arbitrarily — export A to H as one section, then the identifying columns plus I to P as another, so every page carries the row labels. Merge the sections into one PDF afterwards.
Why did my fonts change in the exported PDF?
Excel does not embed fonts by default in several versions, so a corporate typeface gets substituted on another machine. That also changes column widths, which can push a column onto the next page. Enable font embedding in the save options.