How to turn a spreadsheet into a PDF without losing the right-hand columns

You export a spreadsheet to PDF and the last three columns have vanished onto pages of their own, stranded from the row labels that made them meaningful. Or the whole thing has been shrunk until the numbers are unreadable.

This is not a conversion bug. It is the consequence of a difference between the two formats that is easy to overlook.

Spreadsheets have no pages

A document has pages built in. You can see where one ends. A spreadsheet does not: it is an unbounded grid, and it has no opinion about where a page would end because it never needed one.

So exporting to PDF means imposing pages on something that had none, and every decision about where to cut has to come from somewhere. If you have not set those decisions, defaults apply, and the defaults were not chosen with your data in mind.

This is also why the same file gives different results on different machines. Page setup depends on paper size and printer defaults, so a sheet that fitted neatly for you can break differently for a colleague.

The four settings that decide everything

• Print area: which cells are included at all. Without one, the export can extend to every cell that has ever contained anything, including formatting far below your data
• Orientation: landscape suits wide tables and is almost always the right answer for a spreadsheet
• Scaling: fit to one page wide is the setting that solves stranded columns
• Repeating title rows and columns: makes every page carry the headers, so page four is still readable

Fit to one page wide is the important one, and it is different from fit to one page. Fitting everything onto a single page shrinks a long table until nothing is legible. Fitting to one page wide constrains only the width and lets the rows run over as many pages as they need, which is almost always what you actually want.

Set it up before exporting

1. Select your data and set it as the print area, so nothing stray is included.
2. Switch to landscape unless the table is genuinely narrow.
3. Set scaling to fit one page wide, leaving the height unconstrained.
4. Set the header row to repeat on every page, and the label column too if the table is wide.
5. Use the print preview to page through the result before exporting, since it shows exactly what the PDF will contain.

Print preview is doing the real work here. It is the same pagination the export uses, so anything that looks wrong there will be wrong in the PDF, and it takes seconds to check.

When the table is simply too wide

Some tables cannot be made readable on a portrait page at any scale, and forcing them produces a PDF nobody can use. There are better options than shrinking.

Split the table across logically grouped sheets — one per region, per quarter, per product line — and export those. Or hide the columns the reader does not need for this particular purpose; a PDF is a snapshot for an audience, not an archive of everything. Or use a larger paper size, since A3 exists and is a perfectly reasonable answer for a wide financial table.

And consider whether a PDF is the right format at all. If the recipient needs to filter, sort or recalculate, send the spreadsheet. A PDF is right when you want a fixed record everyone sees identically, and wrong when the point is to let someone work with the numbers.