Will the formulas be visible in the PDF, or just the computed values?

Just the computed values. PDF is a flat presentation format; it stores what the spreadsheet looked like at the moment of export, not the underlying formulas. If you need both the formula visibility and the formatted output, two options: (a) export twice, once normally and once with View → Show Formulas enabled, and combine the resulting PDFs; (b) use a side-by-side workbook layout where adjacent cells show the formula as text (=FORMULATEXT(A1)) so the export captures both.

How do I make sure my header row appears on every PDF page?

In Excel: File → Page Setup → Sheet tab → "Rows to repeat at top" → click into the field and select row 1 (or whichever row holds your header). The reference will appear as $1:$1. Save and export. The header row will now appear at the top of every page of the resulting PDF — essential for multi-page tables where readers need to know what each column is.

Why does my wide spreadsheet split across two pages horizontally?

Because Excel's default page-break logic places a vertical page break at the right margin of whichever column happens to fit. The fix is in Page Setup → Page tab: under "Scaling", choose "Fit to 1 page wide by [blank] tall". Excel will compress the table horizontally so it fits one page width. If the compression makes the text too small, switch the orientation to Landscape — most wide tables fit one landscape page comfortably after a small scaling adjustment.

Are confidential spreadsheets safe with a free online converter?

Only if the converter runs client-side. ScoutMyTool's Excel-to-PDF tool runs entirely in your browser tab — your spreadsheet is parsed with JS (SheetJS) and the resulting PDF is built with pdf-lib, both open-source, neither sending data to a server. Server-based converters (Smallpdf, iLovePDF, Adobe online) upload your file, process it on their infrastructure, and stream back the result. For financial models, salary data, customer lists, or any spreadsheet containing PII, the client-side path is the only one that keeps the data off third-party infrastructure.

Can I export just one sheet or a specific cell range?

Yes. Two approaches. (a) Set a print area: select the cells you want, then Page Layout → Print Area → Set Print Area. The PDF export will only include that range. (b) Pick the specific sheet at export time: in the Save as PDF / Export dialog, choose "Active sheet" or pick sheets by name. The print area survives across exports; the dialog-level selection is per-export.

Will my Excel comments / threaded notes appear in the PDF?

Not by default. Excel comments are an on-screen popover feature that is excluded from PDF export unless you opt in via Page Setup → Sheet tab → Comments and notes → "At end of sheet" (lists all comments in a section after the data) or "As displayed on sheet" (shows the comment indicators in their cell positions). Choose based on whether the audience needs to see the discussion threads or just the final values.

How do I handle a workbook with 50 sheets?

Two paths. (a) Export the entire workbook as one PDF — the resulting file is long but each sheet starts on its own page, and the PDF outline includes one bookmark per sheet name. (b) Export each sheet as a separate PDF, then merge selectively. The single-PDF-with-bookmarks path is usually better for review; the per-sheet-PDFs path is better for sharing specific sheets without sending the whole workbook. ScoutMyTool's Merge PDF tool handles the combine step if you go path (b).

Excel to PDF — convert spreadsheets with formatting intact (2026)

11 min read

Excel to PDF — convert spreadsheets with formatting intact (2026)

By ScoutMyTool Editorial Team · Last updated: 2026-05-19

The first time I exported a budget spreadsheet to PDF for a board pack, the resulting file had column G splitting awkwardly across pages 1 and 2, no header row on page 2, and a comment from a colleague calling row 47 "absolutely catastrophic" rendered prominently in the margin. I had skipped Page Setup entirely. Excel exports happily even when no thought has gone into how the spreadsheet will sit on a printed page — and "happily" means producing output that almost always needs a second pass. This article is the version of Excel-to-PDF setup I now do every time before exporting, with the specific gotchas that catch new users and the workflow that produces clean, board-ready output.

Why Excel → PDF is trickier than Word → PDF

A Word document has a clear left-to-right, top-to-bottom flow — paragraphs wrap and the next page starts when the current page fills. A spreadsheet has no such flow. Cells live on an infinite two-dimensional grid; "page breaks" are an artificial construct that Excel chooses based on a combination of column widths, row heights, page size, orientation, scaling, and explicit page-break overrides. The default choices are rarely the right ones for a printed pack, which is why "just save as PDF" almost never produces what you actually wanted on the first try.

The Excel file format itself (.xlsx) is defined by the ISO/IEC 29500 Office Open XML standard, specifically the SpreadsheetML schema, which stores cell values, formats, and page-setup parameters as structured XML.¹ The PDF exporter reads those page-setup parameters — orientation, scaling, print area, repeating rows — and uses them to decide where to break each PDF page. Configure them properly and the PDF lands right. Skip them and the PDF lands wrong.

What survives the export, and what does not

Element	Survives?	Notes
Cell values	Yes	Visible text exactly as it appears in the cell, including number-format-applied display (e.g., "$1,234.56").
Number / currency / date formats	Yes	Custom formats like #,##0.00 or "MMM d, yyyy" are applied before export — the PDF shows formatted output, not raw values.
Formulas	No (values only)	The PDF shows the computed value of each formula at export time. The formula itself is not stored in the PDF.
Cell borders and shading	Yes	Borders are drawn as PDF path operators; fills as filled rectangles.
Conditional formatting	Yes	Applied formatting (highlight colours, data bars, icon sets) is rendered as static content in the PDF.
Charts	Yes	Rendered as embedded vector graphics. Crisp at any zoom.
Hidden rows / columns	Hidden — not included	Anything currently hidden in the source workbook is excluded from the PDF unless you unhide before exporting.
Filters	Visible-only	Only rows currently visible through the filter are included. Filtered-out rows are not exported.
Comments / threaded notes	Optional	Off by default. Toggle "Include comments" in Page Setup to print them at the end or in-cell.
Frozen panes	No (geometric only)	Freeze panes are an on-screen layout aid; they do not affect the PDF. Use "Print Titles" to repeat header rows on every PDF page instead.
Page-setup options (orientation, scaling)	Yes	Page Setup → Page tab and Sheet tab determine where columns wrap and where rows break across PDF pages.

The Page Setup checklist that fixes 90% of problems

Before exporting, run through this five-item checklist. It takes thirty seconds and prevents almost every "the PDF looks wrong" surprise.

Set the print area. Select the cells you actually want in the PDF (skip empty columns to the right of the data, scratch-pad rows below, working ranges off to the side). Page Layout → Print Area → Set Print Area. The export will now include only that range.
Pick orientation. Portrait for tall narrow data, Landscape for wide tables. If you have any doubt, Landscape. Page Layout → Orientation.
Fit the width. Page Layout → Width → "1 page". Excel will scale the print area so the table fits one page wide. If the resulting scale is too small (text below ~8 pt), increase the page width by removing optional columns or widening to a larger paper size.
Repeat the header row. Page Layout → Print Titles → Rows to repeat at top → $1:$1 (or the row your headers actually occupy). On every PDF page after the first, the header row will reappear at the top — essential for multi-page tables.
Decide on gridlines and headings. By default, the cell gridlines and the row/column letter-number headers do not print. If you want gridlines visible in the PDF for cell separation, tick Page Layout → Gridlines → Print. Row numbers and column letters can be added for review drafts via Page Layout → Headings → Print.

Six common gotchas and their fixes

Problem	Root cause	Fix
Wide table is split awkwardly across multiple PDF pages	No print area set; default page-break logic chops at the right margin of whichever column hits the edge first.	File → Page Setup → "Fit to 1 page wide by N pages tall" (Microsoft "Scaling" option) — the table compresses horizontally to fit one page width. Or change orientation to Landscape if 1-page-wide-portrait would shrink content too far.
Header row only appears on the first PDF page	Excel does not repeat the header row by default; you have to opt in via Page Setup → Sheet tab → "Rows to repeat at top".	Page Setup → Sheet → Print Titles → Rows to repeat at top = $1:$1 (or whichever row holds the header). The header row will then appear at the top of every subsequent PDF page.
Currency / date display is wrong in the PDF	A cell's number format applies in Excel and is honoured at export, but the locale used to interpret it may be different on the destination machine. For example, "1,234.56" vs "1.234,56".	Apply explicit number formats (Home → Number group → custom format) rather than relying on locale defaults. The PDF then locks in the display you intended, regardless of the reader's locale.
Some columns appear blank in the PDF	Column was set to width 0 (effectively hidden) or its content is too wide and Excel decided to truncate at the cell border without spilling.	Unhide any 0-width columns, and use Format → AutoFit Column Width before exporting to ensure visible content fits.
The PDF includes every sheet in the workbook, even ones you did not want	File → Save as PDF defaults to "Active sheets" but if you have multiple sheets selected (Ctrl-clicked the tabs), all of them get exported.	Click a single sheet tab before exporting, or pick "Workbook" or "Selection" explicitly in the export dialog. Most tools also let you pick specific sheets by name.
The PDF is enormous (50+ MB)	Embedded images on the sheet, or a chart with high-resolution raster components, are being preserved at original quality.	Compress images in Excel (Format → Compress Pictures) before exporting. After exporting, run the result through ScoutMyTool's Compress PDF tool with the medium preset.

Exporting via ScoutMyTool — five steps

Open the tool. Go to scoutmytool.com/pdf/excel-to-pdf. The tool runs entirely in your browser tab; your workbook never leaves your machine.
Drop in the .xlsx (or .xls / .csv). The tool parses the file with SheetJS — the open-source JavaScript library for Excel-format reading and writing.
Pick the export options. All sheets or specific sheets, orientation (portrait or landscape), fit-to-page (1-page-wide is the safe default), and whether to repeat the header row.
Click Convert. The tool composes the PDF using pdf-lib, applying your page-setup choices and embedding each sheet starting on its own page. A bookmark tree is added so the recipient can jump between sheets from the PDF sidebar.
(Optional) Compress before emailing. If the workbook contained embedded images that bloated the output, run the result through Compress PDF with the medium preset.

CSV files have no formatting information at all — no cell colours, no number formats, no fonts. Exporting a CSV directly to PDF produces a basic table with default formatting. Two paths from there: (a) use ScoutMyTool's CSV to PDF for a plain structured-data export with sensible defaults; (b) open the CSV in Excel first, apply formatting (currency for money columns, dates for date columns, freeze panes for the header), then export with the full Excel-to-PDF flow. The Excel-first path is slower but produces a much more presentable PDF for any data you intend to share.

The reverse direction is harder

PDF → Excel is materially harder than Excel → PDF, for the same reason PDF → Word is harder than Word → PDF. PDF stores cell content as positioned glyphs on a flat canvas, not as a structured grid. Converters have to guess where the rows and columns of the original spreadsheet were, and the guess is rarely perfect on complex layouts. If you might ever need to round-trip a spreadsheet through PDF, keep the original .xlsx around as the source of truth — the PDF version is a presentation artefact, not a substitute for the workbook. ScoutMyTool's PDF to Excel tool handles the reverse for clean cases but degrades on multi-table pages.

Excel to PDF — the primary tool referenced.
PDF to Excel — the reverse direction.
CSV to PDF — for plain CSV inputs.
PDF to CSV — for extracting tabular data from PDFs.
Compress PDF — shrink the exported file before emailing.
Merge PDF — combine per-sheet exports into a single workbook PDF.
Add Page Numbers — paginate multi-page spreadsheet PDFs.
PDF to PowerPoint converter — sister article on the slide direction.
PowerPoint to PDF — sister article on the slide direction.

Frequently asked questions

Will the formulas be visible in the PDF, or just the computed values?: Just the computed values. PDF is a flat presentation format; it stores what the spreadsheet looked like at the moment of export, not the underlying formulas. If you need both the formula visibility and the formatted output, two options: (a) export twice, once normally and once with View → Show Formulas enabled, and combine the resulting PDFs; (b) use a side-by-side workbook layout where adjacent cells show the formula as text (=FORMULATEXT(A1)) so the export captures both.
How do I make sure my header row appears on every PDF page?: In Excel: File → Page Setup → Sheet tab → "Rows to repeat at top" → click into the field and select row 1 (or whichever row holds your header). The reference will appear as $1:$1. Save and export. The header row will now appear at the top of every page of the resulting PDF — essential for multi-page tables where readers need to know what each column is.
Why does my wide spreadsheet split across two pages horizontally?: Because Excel's default page-break logic places a vertical page break at the right margin of whichever column happens to fit. The fix is in Page Setup → Page tab: under "Scaling", choose "Fit to 1 page wide by [blank] tall". Excel will compress the table horizontally so it fits one page width. If the compression makes the text too small, switch the orientation to Landscape — most wide tables fit one landscape page comfortably after a small scaling adjustment.
Are confidential spreadsheets safe with a free online converter?: Only if the converter runs client-side. ScoutMyTool's Excel-to-PDF tool runs entirely in your browser tab — your spreadsheet is parsed with JS (SheetJS) and the resulting PDF is built with pdf-lib, both open-source, neither sending data to a server. Server-based converters (Smallpdf, iLovePDF, Adobe online) upload your file, process it on their infrastructure, and stream back the result. For financial models, salary data, customer lists, or any spreadsheet containing PII, the client-side path is the only one that keeps the data off third-party infrastructure.
Can I export just one sheet or a specific cell range?: Yes. Two approaches. (a) Set a print area: select the cells you want, then Page Layout → Print Area → Set Print Area. The PDF export will only include that range. (b) Pick the specific sheet at export time: in the Save as PDF / Export dialog, choose "Active sheet" or pick sheets by name. The print area survives across exports; the dialog-level selection is per-export.
Will my Excel comments / threaded notes appear in the PDF?: Not by default. Excel comments are an on-screen popover feature that is excluded from PDF export unless you opt in via Page Setup → Sheet tab → Comments and notes → "At end of sheet" (lists all comments in a section after the data) or "As displayed on sheet" (shows the comment indicators in their cell positions). Choose based on whether the audience needs to see the discussion threads or just the final values.
How do I handle a workbook with 50 sheets?: Two paths. (a) Export the entire workbook as one PDF — the resulting file is long but each sheet starts on its own page, and the PDF outline includes one bookmark per sheet name. (b) Export each sheet as a separate PDF, then merge selectively. The single-PDF-with-bookmarks path is usually better for review; the per-sheet-PDFs path is better for sharing specific sheets without sending the whole workbook. ScoutMyTool's Merge PDF tool handles the combine step if you go path (b).

Convert your Excel to PDF, free

Browser-only — your workbook never leaves your machine. Fit-to-page, repeating headers, and per-sheet bookmarks included.

Open the free Excel to PDF tool →

Excel to PDF — convert spreadsheets with formatting intact

Introduction