Excel to PDF — keep formulas readable and tables intact

Step-by-step: convert XLSX to PDF the way the document needs

The ScoutMyTool tool lives at scoutmytool.com/pdf/xlsx-to-pdf. Runs client-side — no upload, no signup, no quota.

1. Drop your XLSX. Loads into a sandboxed memory buffer; nothing is uploaded.
2. Pick the formula display mode. Default "Computed values" (the way Excel shows the spreadsheet). Switch to "Show formulas" for audit / documentation workflows; cells with formulas display their formula text instead of the calculated result.
3. Toggle "Keep tables intact". On by default — the layout engine respects named-table and auto-detected table boundaries, breaking pages around them rather than through them. Turn off for raw data dumps where the page-break boundary does not matter.
4. Pick multi-sheet behaviour. Default "One combined PDF" — each sheet starts a new page with the sheet name in the header and a PDF bookmark. Toggle "One PDF per sheet" for zip output with separate PDFs.
5. Configure page setup. Default matches the XLSX's page setup (Letter / A4, portrait / landscape, fit-to-page). Override per-sheet by clicking the sheet name in the preview pane. Useful for mixed workbooks where one sheet wants landscape and the rest portrait.
6. Set "Repeat top rows". Auto-detects from freeze panes / print titles. Override here to repeat specific rows on every continuation page. Critical for long tables where the column headers should always be visible.
7. Click Convert. The tool evaluates formulas (in "Computed values" mode), renders each sheet's cells to PDF text and graphics objects, and assembles the output. Progress shown live with current sheet / total.
8. Verify in any PDF reader. Open the output, navigate the sheet bookmarks, scroll through long sheets to confirm tables are not split mid-row and headers repeat at the top of each continuation page.

How ScoutMyTool compares to Smallpdf, iLovePDF and PDF2Go

All four offer XLSX-to-PDF conversion. The "Show formulas" mode and explicit table-protection toggle are the differentiators that change how usable the output is for audit workflows.

Why "Show formulas" mode matters for audit-grade documents

The default of any spreadsheet renderer is to show computed values — that is what Excel itself does on screen. But for certain document genres, the formulas are the content:

• Spreadsheet code review. Reviewer wants to see the logic, not just the outputs. "Show formulas" turns the PDF into a flat code-listing of every cell's expression.
• Financial-model documentation. Investment memos often include "show your work" attachments where every line item is documented with the underlying calculation.
• Tutorial materials. When teaching pivot tables, lookups, or array formulas, the printed PDF needs to show the formula text alongside the result.
• Audit trail. External auditors (SOX, IFRS) often request formula-visible exports as part of working papers, where the auditor needs to trace each line item back to its source calculation.

Mechanically, "Show formulas" maps to Excel's built-in View → Show Formulas toggle (Ctrl-`). The tool reads each cell's formula property — defined in OOXML / ECMA-376 §18.3.1.40¹ — and renders that string instead of the cached result.

Related PDF tools on ScoutMyTool

• Excel to PDF — the tool this guide is about.
• PDF to Excel — the reverse conversion (when the document started as a PDF).
• PDF to Excel guide — broader article on extracting tables from PDFs.
• Word to PDF — for the document equivalent.
• PowerPoint to PDF — for slide-deck exports.
• Merge PDF — combine the spreadsheet-PDF with other documents.
• Compress PDF — shrink the output before sharing.

Frequently asked questions

I need the formulas visible in the PDF, not the calculated values. How?

Toggle "Show formulas" before clicking Convert. This switches the rendering from "show what the user sees" to "show what is in the cell" — every formula cell displays its formula text (=SUM(B2:B10), =VLOOKUP(...), etc.) instead of the computed result. Useful for documenting spreadsheet logic, code-review style audits, and tutorials where the formula text IS the content. The default mode (showing computed values) is right for almost every other use case — a printed financial report should display the numbers, not the formulas that produced them.

My tables get cut in half by page breaks. How do I keep them whole?

Toggle "Keep tables intact". With this on, the layout engine treats each named Excel table (or auto-detected contiguous data block) as an atomic unit that should not be split across pages. If a table fits on the page being filled, it goes there; if not, it breaks to a new page and starts there. The trade-off is some blank space on pages above tables that almost-fit, but the readability gain on cross-page tables is almost always worth it. For pure data dumps where every row needs to be on a numbered page in sequence regardless of layout, turn this off — Excel's default break-anywhere behaviour is the right answer.

Will multi-sheet workbooks export as one PDF or several?

One PDF by default, with each sheet starting on a new page (and the sheet name appearing in the page header). Toggle "One PDF per sheet" to get a zip of separate PDFs instead — useful when you want to send only specific sheets to different recipients without splitting after the fact. The PDF outline (bookmarks) is auto-populated with one entry per sheet, so navigation in the combined PDF mirrors the workbook tab structure.

How does the tool handle freeze panes and print titles?

Freeze panes are honoured for header rows / leftmost columns — the frozen rows repeat at the top of each continuation page, which is what readers expect from a printed report. Print titles set via Excel's Page Layout menu take precedence over freeze panes if both are set. If neither is configured, the tool falls back to detecting a likely header row (first row of bold text or first row that differs in fill colour from the data below) and repeats that. Override the auto-detect via the "Repeat top rows" field.

Is my XLSX uploaded to your servers?

No. The conversion runs entirely in your browser. XLSX is a zip of XML documents (OOXML); the tool unzips, parses the sheet XML, evaluates formulas (if not in "show formulas" mode), and renders each sheet to PDF pages via pdf-lib. Verify in DevTools Network — zero outbound requests during conversion. Important for spreadsheets containing personally identifiable data (employee compensation, customer lists, financial models) that should not be uploaded to a competing cloud tool.

Does Excel formatting (fonts, colours, borders, conditional formatting) survive?

Yes, for the vast majority of formatting. Fonts (including the exact font face if present on the device, with a close substitute otherwise), font colours, fill colours, borders, number formats, alignment, merged cells, and conditional formatting rules are all evaluated and rendered. Edge cases that may differ: very recent conditional formatting types (Excel 365 features released in the past 6–12 months), embedded chart objects rendered as static images, and some pivot-table interactive features which are collapsed to their static snapshot.

Can I print only a specific cell range?

Yes. Set a "Print area" in Excel before exporting (Page Layout → Print Area → Set Print Area) and the tool respects it, exporting only that range as the PDF content for that sheet. Alternatively, type a range in the tool's "Override print area" field — e.g. "A1:G50" — and it applies regardless of the workbook's built-in setting.