Excel to PDF: how to stop it splitting across pages

Converting a spreadsheet to PDF is easy. Converting one that still makes sense afterwards is where it goes wrong, and it nearly always goes wrong the same way: the last three columns end up on their own page, orphaned from the row labels that made them meaningful.

The cause is simple. Spreadsheets grow sideways and paper does not.

Why a spreadsheet doesn't fit paper

A document has a width — the page it was written for. A spreadsheet has no width at all. It keeps going right for as long as you keep adding columns, and nothing in the file says where a page should end. So something has to decide, and by default it decides badly: fill the page, then start another.

The four fixes, in the order worth trying

1. 1Switch to landscape. A4 in landscape is 297mm wide against 210mm — roughly 40% more room, for free, and it is the right default for almost every sheet.
2. 2Scale to fit the page width. This shrinks everything proportionally so no columns are lost. It is the fix that works most often, and it has a limit worth knowing about (below).
3. 3Hide the columns you don't need. Working columns, intermediate calculations and internal notes rarely belong in something you are sending out. Hidden columns are left out of the PDF entirely.
4. 4Use a bigger page. A3 is double the area of A4, and if the sheet is going to be read on screen rather than printed, nothing is lost by using it.

Try them in that order. Landscape and hiding columns cost you nothing in legibility; scaling costs a little; a bigger page only matters if someone actually prints it.

The limit on scaling

Fit-to-width can always make a sheet fit — by making the text unreadable. Past roughly a third of full size, figures stop being legible, and a page that technically contains every column but cannot be read is no more useful than one with columns missing.

So there is a floor. When a sheet is too wide to fit legibly, the honest response is to say so rather than shrink it into illegibility, which is what the tool below does — it stops at that floor and tells you, so you can go back and hide some columns instead.

Converting the spreadsheet

1. 1Open the Excel to PDF tool. Landscape and fit-to-page-width are already on, because they are right far more often than not.
2. 2Drop the .xlsx in. Only .xlsx works — a .xls is a pre-2007 binary format, and a .csv has no formatting, column widths or sheets to convert at all.
3. 3Choose your gridlines. "Match the sheet" follows whatever the spreadsheet does, which is usually what you want.
4. 4Run it, then read the note: it says how much the sheet was scaled, and warns you if it hit the legibility floor.

One thing worth checking afterwards

Look at your dates and your money columns. Excel does not store a date — it stores a number like 46251, plus a separate instruction to display that number as a date. It does not store 12.5% either; it stores 0.125.

A conversion that reads the values and ignores those display instructions hands you a document full of five-digit integers where the dates used to be. Everything else can look perfect and the document is still useless. It is the fastest way to tell whether a converter was written carefully.

Common questions

How do I fit a wide Excel sheet on one PDF page?

Landscape first, then scale to fit the page width, then hide the columns you do not need, then move to a larger page size such as A3. In that order, because the first and third cost you nothing in readability.

Do my cell colours and borders survive?

They should. A .xlsx states its own appearance — fills, fonts, borders, alignment, column widths, row heights, merged cells and number formats — and a conversion that reads the file properly keeps all of it. What no browser can draw is charts and pivot tables.

Why don't my charts appear?

A chart in a spreadsheet is not a picture. It is a description of data series pointing at cell ranges, so drawing one means reimplementing Excel's chart engine — and something that looks approximately right but plots subtly wrong is worse than leaving it out. Copy the chart into the sheet as a picture first if you need it.

Are gridlines included?

By default they follow the sheet: showing in Excel means showing in the PDF. Worth knowing that Excel's own print default is the opposite — it hides gridlines when printing unless you turn them on — so this deliberately differs, because a table without lines is harder to read on paper.

Will hidden rows and sheets show up?

No. Hidden rows, hidden columns and hidden sheets are left out, on the assumption they were hidden deliberately. Each visible sheet starts on a new page.