Exporting a Word document to PDF is easy (see our Word→PDF guide) because a Word page already looks like a printed page. Spreadsheets are a different animal: your data is a grid that scrolls forever, and a PDF is a fixed stack of pages. That mismatch is the source of every classic spreadsheet-to-PDF disaster — cut-off columns, text shrunk to ant size, headers that appear once and vanish.
The fix isn't a better converter. It's understanding that “converting Excel to PDF” is really printingto PDF — and treating page setup as the main event.
The mental model: you're printing, not converting
When Excel makes a PDF, it renders your sheet exactly as it would look coming out of a printer: margins, page breaks, scaling, the lot. If the Print Preview looks wrong, the PDF will look wrong in exactly the same way. So the workflow is always:
- Open Print Preview first (Ctrl+P / Cmd+P) — never export blind.
- Fix the layout problems you see.
- Then choose PDF as the printer/destination.
This one habit eliminates 90% of broken spreadsheet PDFs. Every method below — desktop, web, phone — flows through this preview.
Excel desktop: the reliable path
With the spreadsheet open, press Ctrl+P (or File → Print) and set the destination to Microsoft Print to PDF — or use File → Export → Create PDF/XPSfor more options. Before you hit print, get these settings right:
- Scaling: Fit Sheet on One Page. In the Settings dropdown, this is the single most important control. It shrinks your sheet to fit one page wide and tall. For wide tables, “Fit All Columns on One Page” keeps everything readable while allowing multiple pages downward.
- Orientation: Landscape. Tables are wider than they are tall; portrait orientation is the #1 cause of cut-off columns. Flip it.
- Print Area. Select just the cells you want, then Page Layout → Print Area → Set Print Area. Stops stray columns and blank pages with invisible formatting.
- Print Titles. Page Layout → Print Titles → Rows to repeat at top, and pick your header row. Now every page of a long sheet carries its column labels.
- Margins and gridlines. Narrow margins buy space; ticking “Gridlines” under Sheet Options prints the cell borders you see on screen (off by default in print).
Google Sheets: free, no Excel needed
File → Download → PDF Document (.pdf) opens an export dialog with the same concepts:
- Scale: Fit to width — usually the right choice for tables.
- Orientation: Landscape for anything with more than a few columns.
- Repeat row headers on each page — the Sheets equivalent of Print Titles.
- Which sheets: current sheet, all sheets, or a specific cell range. Pick a range to avoid exporting scratch tabs.
- Headers and footers can stamp page numbers, the workbook title, and date on every page automatically.
LibreOffice Calc: the free offline route
LibreOffice is free and opens XLSX files. In Calc, select your data range, then Format → Print Ranges → Define to set the print area, and use the Export Directly as PDF toolbar button. Check the Page Preview (View → Page Break Preview) first — dragging page-break lines in that view is the fastest way to tame a big sheet.
The classic disasters (and their one-line fixes)
- Columns cut off on the right → Landscape + “Fit all columns on one page”.
- Text shrunk to unreadable → You forced too much onto one page. Allow “Fit to 1 page wide by N pages tall” instead of 1×1.
- Page 2+ has no headers → Print Titles / Repeat row headers.
- Random blank pages at the end → Set an explicit Print Area; stray formatting on distant cells creates phantom pages.
- ####### in cells → A column is too narrow for the number. Widen it before exporting — the PDF will show the same error text.
Why we won't ship a fake converter
Spreadsheet-to-PDF is print rendering, and the only engines that do it faithfully live inside Excel, Sheets, and LibreOffice. There's no genuine free in-browser XLSX-to-PDF renderer — any site offering one is running your financial spreadsheets through their server farm. If you wouldn't email the file to a stranger, don't upload it to a converter. The Export menu is already the right tool, and it's private.
After the export: keep the PDF useful
A clean PDF deserves good handling — and that's where tools that genuinely run in your browser help. Merge PDF combines sheets exported separately into one report, Compress PDF shrinks the file for email or uploads, and Text to PDF builds a clean cover page or summary from plain text. If you ever need the reverse trip — pulling editable text out of a PDF — PDF to JPG turns pages into images you can drop into a presentation.