Excel to PDF

A spreadsheet is an unbounded grid. It has no pages, no margins and no notion of where one sheet of paper ends and the next begins — those only appear when something has to print it. Converting to PDF forces every one of those decisions at once, which is why the same workbook can produce a tidy two-page report or a bewildering forty-page spill.

The decisions are made from the print settings stored in the workbook itself, so the conversion honours what you set in Excel: print area, page orientation, scaling, repeated header rows, margins and page breaks. Nothing is invented, and nothing is overridden.

That makes five minutes in Page Layout view the highest-value thing you can do here. Setting the print area to the range that matters, choosing landscape for a wide table, scaling to one page wide, and repeating the header row on every page turns a data dump into something a person can read.

The most important reason is that a PDF cannot be recalculated. A workbook's numbers depend on formulas, and formulas depend on the version of Excel opening them, on regional settings, on external links that may no longer resolve, and on whether the recipient accidentally typed in a cell. A PDF shows the figures as they stood when you sent them, permanently.

It also stops the recipient seeing more than you meant to send. Workbooks carry hidden sheets, working columns, comments, defined names and revision history, and a great many accidental disclosures have come from a spreadsheet sent whole when a table was intended. Converting keeps what prints and leaves the rest behind.

And it opens anywhere. Nobody needs Excel, a compatible version, or the right add-ins — a PDF renders identically on a phone, in a browser and on paper.

Width is where most spreadsheet PDFs fail. A table wider than the paper has to break, and a break in the wrong place separates a row's labels from its numbers, leaving pages of figures with no indication of what they describe.

Three settings fix nearly all of it. Landscape orientation buys about 40% more width at once. Scale to Fit set to one page wide shrinks the columns until they fit, which is fine down to about 8-point type and unreadable below it. And repeating the label column and header row on every page keeps each fragment interpretable even when a break is unavoidable.

When a table genuinely cannot fit legibly, splitting it deliberately beats scaling it into illegibility — two logical groups of columns on two pages, each with the labels repeated, is far more usable than one page nobody can read.

Financial and commercial spreadsheets are the everyday case here, and they usually want something applied to the result. Protect PDF adds a password and disables copying for anything with figures that should not circulate. Sign PDF places a signature on a converted invoice or statement.

Watermark PDF marks a converted report as DRAFT or CONFIDENTIAL, which matters more for spreadsheets than most documents because a table of numbers carries no visual cue about its status.

If the PDF needs to be part of something larger — a board pack, a tender response — Merge PDF combines it with the other sections, and Add Page Numbers makes the assembled document navigable.