How to convert Excel (XLSX) to PDF correctly
Spreadsheets are the format people get wrong most often when exporting to PDF. The default Excel export prints whatever fits on a page and chops the rest, leaving you with a mystery PDF where the right-hand columns are missing. This guide is about the four print settings that decide whether your XLSX becomes a clean, readable PDF — print area, page orientation, scaling, and repeating headers — plus the tools that handle them automatically.
- Set the print area. Highlight only the cells you want in the PDF, then Page Layout → Print Area → Set Print Area. Without this, Excel exports every cell that has ever held a value, including invisible whitespace far to the right.
- Choose orientation and scaling. In Page Layout → Orientation, pick Landscape for wide tables. In Scale to Fit, set Width to 1 page and leave Height empty — that forces every column onto the same sheet without making rows microscopic.
- Repeat the header row. Page Layout → Print Titles → Rows to repeat at top: pick row 1 (or wherever your header is). Now every PDF page starts with the same column headers, so the second and third pages still make sense.
- Export as PDF. File → Save As → PDF, or File → Export → Create PDF. Tick "Selection" if you only want the print area, or "Active Sheet" / "Entire Workbook" depending on what you need. Open the PDF and verify the page count matches your expectation.
Your files stay on your device
All processing happens locally in your browser using JavaScript. We never upload, store or look at your files.
Real spreadsheets and how to set them up
A monthly expense report
Set the print area to your data range, switch to landscape, fit width to 1 page, repeat the header row. The accountant gets one PDF where every page has the same column headers and nothing is clipped.
An inventory list with 40 columns
Don't try to fit it on one page — fit width to 2 pages and let the rows split naturally. Add Print Titles for both the top header row and the first column (item code), so every page is self-explanatory.
A quote or invoice built in Excel
Use a Print Area covering only the visible quote, switch to portrait, fit width to 1 page. The result is a clean one-page PDF you can email — no mystery extra blank pages from cells that used to have content.
A dashboard with charts
Charts export beautifully if you give them their own Print Area and set page breaks manually. View → Page Break Preview lets you drag the dashed lines so each chart lands on its own page.
Excel-to-PDF problems and fixes
The PDF has hundreds of empty pages
Excel "remembers" cells that ever held data. Press Ctrl+End to see where the data range ends — if it's far past your real data, delete the empty rows/columns, save, and re-export. Setting an explicit Print Area also fixes it.
Columns are cut off on the right
You exported in portrait without scaling. Switch to landscape and set Scale to Fit → Width = 1 page. If you have more than ~12 columns, allow 2 pages wide and use Print Titles to repeat the first column.
Numbers show as ###
The column is too narrow at the printed size. Auto-fit columns (double-click the column border) before exporting; on landscape with Width = 1 page, columns then size themselves to fit the printable area.
Cell formatting (colours, borders) looks faded
Page Layout → Sheet Options → Print: tick Gridlines if you want them, and check Black and White is OFF. Also confirm "Draft quality" is unchecked under Page Setup → Sheet.
Hyperlinks in cells aren't clickable in the PDF
Excel's Save As → PDF and Export PDF both preserve cell hyperlinks. "Print to PDF" via the OS doesn't — it flattens everything to pixels. Use Save As, not Print, when you need clickable links.