Converting Excel to PDF

Why spreadsheets fight the PDF format

PDF is built around fixed pages; spreadsheets are built around boundless grids. Somewhere in the conversion, the grid must be chopped into pages, and every decision — which columns fit, where rows break, what scales down — gets made at that moment. Word documents convert easily because they already think in pages. Spreadsheets need you to impose page thinking first, which is why an unprepared sheet converts into a chopped, shrunken, page-fragmented mess.

The good news: the same three preparations fix almost every case — print area, scaling, and break placement.

Print area: the single highest-leverage fix

The print area defines which cells even enter the conversion. Without one, everything with content does — including the scratch calculations in columns R through X, the draft notes below row 200, and every helper column. Setting the print area to the report region alone instantly deletes most conversion disasters.

The rule: select the table you actually intend to share, set it as the print region, and convert that. If the document has two report regions with scratch work between them, convert them as separate PDFs and merge — cleaner than fighting one awkward region.

Scaling: fit-to-width is almost always right

The scaling decision has two sane options and one trap. Fit-to-width shrinks all columns enough to keep them on one page horizontally — the correct choice for nearly every report, because a table split mid-column is unreadable. Full size keeps columns at natural width and lets them break across pages — acceptable only for genuinely wide engineering-style tables where readers expect page turns. The trap is default 'fit everything to one page' on a long table: it produces a PDF where text is microscopic.

The practical test after converting: can the smallest number in the table be read at normal zoom without squinting? If not, reduce columns (hide or drop low-value ones) rather than shrinking further.

Row breaks across pages

When a table runs many pages, two settings decide readability. Repeat the header row on each page — without it, page three of a budget shows numbers with no column labels. And keep logical groups intact: a row group splitting across a page break can be fixed by inserting the break above the group. Both are thirty-second fixes before conversion that save recipients genuine confusion.

Multi-sheet files: decide what ships

Workbooks accumulate sheets — quarterly tabs, archived versions, calculation sheets. Converting the whole file bakes all of it into the PDF, and the scratch sheets almost never belong in the deliverable. The discipline: identify the reporting sheets, convert those, and leave the machinery behind. If the recipient needs both the report and the data, send the PDF and the original workbook separately — mixing them in one PDF helps neither use.

Numbers, formatting, and frozen values

PDF freezes displayed values — which means formulas disappear and rounding displays become permanent. Two consequences: recipients cannot audit calculations (send the workbook if audit matters), and any cell showing ##### (column too narrow for the number) converts that error glyph faithfully. Scan the print area for ##### and truncation before converting; they are invisible in the normal zoom-out view.

Local conversion for financial documents

Spreadsheets converted to PDF are disproportionately financial — budgets, invoices, forecasts, payroll summaries. Local conversion in the browser matters proportionally: the workbook is parsed and rendered on your machine, and the PDF downloads without the numbers ever sitting on a conversion server. For client financials under embargo, this is not a preference but a requirement.

Charts and conditional formatting fidelity

Charts convert as rendered images and usually survive faithfully — the one caveat is resolution on scaled-down pages, where chart labels can blur. Conditional formatting (color scales, data bars) also transfers as rendered appearance, which is good for reports but means the colors carry no underlying logic in the PDF. If recipients need to filter or re-sort, they need the workbook; the PDF is the frozen presentation layer.

Invoice-style sheets: the portrait exception

Most reports want landscape, but invoice and receipt layouts are designed portrait and narrow. Forcing fit-to-width on a portrait invoice scales it up oddly or wastes half the page. The fix: set the print area tightly around the invoice block and let it occupy its natural region with margins — documents designed for a shape should keep it, and the width-scaling rule applies to wide tables, not shaped layouts.

Printing from the PDF versus the workbook

One subtle difference: printing from the converted PDF reproduces exactly what you see — the frozen layout with page breaks as designed. Printing from the workbook re-runs the print pipeline and can shift depending on printer drivers and paper settings. For documents where physical print fidelity matters (contracts, filed reports), distribute the PDF and instruct recipients to print from it — the PDF is the only version guaranteed to match what you proofed.

Making spreadsheets read well as documents

Spreadsheets are built for the grid; PDFs are built for the page, and the conversion forces a reconciliation. The first decision is scope: a full sheet with 200 columns becomes a microscopic PDF, while the relevant range — selected before conversion — becomes a legible document. Print-area discipline is the skill that separates professional-looking PDF output from screenshot-grade exports: define exactly which cells matter and convert only those.

Scaling behavior is where most conversions go wrong. Fit-to-one-page shrinking turns dense data into unreadable type; the better pattern is choosing the paper orientation that suits the data (landscape for wide tables), letting the table flow across pages, and repeating header rows on each page so page 4 is readable without page 1. A PDF whose continuation pages lack column labels is a document people print and immediately regret.

Number formatting deserves a final check after conversion because PDFs freeze what Excel renders. Currency symbols, thousand separators, and decimal precision all carry through exactly as displayed — including inconsistencies like one column formatted as text and another as numbers. The PDF is also where conditional formatting reveals itself as either helpful emphasis or visual noise; review one representative page at actual print size before exporting the whole workbook.

Common mistakes with this tool

• Converting without a print area and shipping scratch columns.
• Fitting a long table to one page and producing microscopic text.
• Letting tables split mid-column instead of scaling to width.
• Shipping `#####` cells because nobody checked column widths pre-conversion.

Frequently asked questions

How do I convert an Excel spreadsheet to PDF?

Add the workbook, choose the sheet or print area, and convert — the rendered pages download as a PDF.

Why do my columns cut off across pages?

Set scaling to fit-to-width so all columns stay on one horizontal page.

Do formulas survive the conversion?

No — PDF freezes displayed values. Send the workbook alongside if recipients need the calculations.

Can I convert multiple sheets?

Yes, but convert only reporting sheets — scratch and archive tabs rarely belong in a deliverable.

Is it safe for financial documents?

Yes — conversion is local; the workbook never uploads.

Why are my spreadsheet's columns cut off in the PDF?

The content exceeds one page width and got clipped or shrunk. Set the print area to the relevant range, switch to landscape, or let the table span pages with repeated header rows.

Can people edit the numbers in the PDF?

No — PDF freezes the rendered values; formulas and cell structure do not survive. The PDF is a presentation artifact; the spreadsheet remains the editable source of truth.