Answers · 30 of them

Answers

Pick the thing that went wrong. Each answer gives you the fix by hand in Excel first, then what CrazySmartPDF does about it, in a couple of minutes of reading.

Start here Why does my Excel spreadsheet look wrong when I save it as PDF Because "Save as PDF" is a print, not a layout: cut-off columns, split rows, shrunk text, data outside the print area, and blank pages all carry straight through. Here is how to diagnose each.

The layout breaks

Rows split down the middle, columns sliced off at the paper edge, text shrunk to nothing. Each one is a page-setup problem with a manual fix in Excel.

How to stop Excel from splitting rows across PDF pages (row-atomic breaks) Excel breaks pages by height, so tall rows split across pages. Insert manual page breaks, or use a renderer that treats every row as atomic so a row never breaks across a page. How to convert Excel to PDF without cutting off columns Excel cuts off columns because it prints at a fixed width that spills past the page edge. Rotate to landscape and fit the width — or use a renderer that measures every column, slices wide tables across pages rather than clipping, and flags any residual clip. How to save Excel as PDF without shrinking the text to fit one page Text shrinks because "Fit Sheet on One Page" scales the whole sheet down. Turn scaling off and let it paginate — or use a tool that re-lays-out at a readable size instead of shrinking. How to make an Excel sheet fit on one page as a PDF Set Page Layout, Scale to Fit, Width to 1 page and leave Height automatic so Excel compresses only the width. Past a point, multi-page with repeated headers beats shrinking. Why Excel page breaks move when you save as PDF (and how to pin them) Excel repaginates against the active printer when it exports, so page breaks you set can shift in the PDF. Here is why it happens, how to pin them, and the tool-side fix. How to repeat the header row on every page of an Excel PDF Multi-page table losing its column headers after page one? Use Page Layout, Print Titles, 'Rows to repeat at top'. Freezing panes does nothing for print. Here is the fix.

One workbook · 23 columns · page 1 of each PDF

Page 1 of Excel's own Save as PDF export: a portrait page carrying only the Invoice No, Issue Date, Due Date, Client, Client ID and Region columns.
Excel · Save as PDF Portrait, 24 pages. Page 1 carries 6 of 23 columns and not one money column. Balance and Status first appear on page 19.
Page 1 of the CrazySmartPDF export of the same workbook: a landscape page carrying all 23 columns, with every row kept whole.
CrazySmartPDF Landscape, 10 pages. Page 1 carries all 23 columns, every row kept whole, wrapped notes and all.

Real output from both tools on the same input file. Sample workbook — every company, invoice number and figure in it was invented. No customer data. Tap either page to open it full size.

Something is missing from the PDF

The export that looks fine and is quietly short a column, a sheet or a page is the one that reaches your reader before you catch it.

How to keep Excel's print area from silently dropping data in the PDF A set print area makes Excel print only that block, so data outside it silently vanishes from the PDF. Clear or widen it in Excel — or use CrazySmartPDF, which renders your whole sheet, not just the boxed-in block. Excel saves only one sheet to PDF - how to export the whole workbook Excel exports only the active sheet by default. Choose Options, Entire Workbook in the Save As dialog, or Ctrl-click the tabs first. Here is how to get all sheets into the PDF. How to put every Excel sheet on its own page(s) in one PDF Group all the sheet tabs before exporting to get each sheet on its own page in one PDF — or use a tool that renders each sheet as its own section, in the order and layout you choose. How to catch blank or clipped pages in an Excel-to-PDF export Excel won't warn you about blank or clipped pages — you have to check the PDF yourself. Or use a self-audit that rasterises every page and flags near-blank and right-edge-clipped pages.

Whole folders, other machines, error messages

What to do when it is not one file, when the machine has no Excel on it, when the workbook cannot be uploaded, and when the export simply refuses.

How to batch-convert a whole folder of Excel files to PDF at once Excel has no built-in folder converter. Use a VBA or PowerShell loop, or a desktop app that renders every .xlsx and .xlsm in a folder to PDF in one pass with a self-check. How to convert Excel to PDF without Excel installed No Office license, borrowed machine, or Mac/Linux? A browser converter turns an .xlsx into a PDF from any machine, and LibreOffice covers the fully-offline case. Here is how. Convert Excel to PDF without uploading it anywhere For workbooks that can't leave your machine, skip the online converters. Excel's own export and CrazySmartPDF's native Windows apps both convert offline. Here is the difference between them. Excel won't save as PDF ('Document not saved') - fixes that work 'Document not saved' on PDF export usually traces to a stuck add-in, an old .xls file, PDF/A being ticked, or a broken default printer. Here are the fixes in order, plus a fallback.

More answers

Combine multiple Excel files into a single PDF No converter merges separate workbooks directly. Convert each file then join the PDFs, or restructure the pack as one multi-sheet workbook that renders to a single PDF in one pass. Converting Excel to PDF from the command line on Windows Three routes: LibreOffice headless, a paid CLI converter, or scripting Excel itself through COM. Each renders your page setup as-is, so fix the layout before you automate it. Excel exports the PDF at the wrong page size (A4 vs Letter) Excel silently swaps A4 and Letter when 'Scale content for A4 or 8.5x11 inch paper sizes' is on. Turn it off in File > Options > Advanced, then set the real size and margins in Page Layout. Excel PDF cuts off text inside cells — why it clips and how to stop it Text that is visible on screen gets truncated in the PDF when the row height was never re-fit after editing, or when wrap text fights a fixed height. Autofit, unmerge, then check the export. Excel to PDF adds extra blank pages — causes and fixes Blank pages in the PDF mean Excel thinks the sheet is bigger than it looks: a stretched used range, a stale print area, or manual page breaks. Here is how to find the cause and clear it. Excel to PDF comes out blurry — fixing image and chart quality Blur comes from Excel's automatic picture compression and from charts being rasterised on export. Turn compression off, set high fidelity, and export through Excel's own engine rather than a re-parser. Excel to PDF on a Mac — what works and what does not Mac Excel exports through File > Save As > PDF with the same pagination quirks as Windows. CrazySmartPDF's native apps are Windows-only; its free web converter runs in any Mac browser. Excel to PDF with (or without) gridlines — the setting that controls it Gridlines in the PDF follow the Page Layout > Sheet Options > Gridlines Print checkbox, set per sheet. The View checkbox only changes your screen. Borders are a separate thing entirely. Excel's 'Fit to One Page' is not working — here is why When Fit to One Page seems ignored, the cause is usually leftover manual page breaks, a stale print area, a stretched used range, or a paper-size mismatch. Clear those and scaling behaves again. How to automate a recurring Excel-to-PDF run For an export you repeat every week or month, the ladder is a saved page setup, a VBA button, a Power Automate flow, or a desktop batch that takes the whole folder in one pass and writes a run log. How to convert .xlsm (macro-enabled) Excel files to PDF Macros do not run inside a PDF, but a macro-enabled workbook converts like any other. Excel's export works, and the free web converter accepts .xlsm directly. Watch for macros that alter the sheet on open. How to convert Excel to PDF without losing formatting "Losing formatting" is really five separate failures: cut columns, split rows, shrunken text, blank pages, and data left outside the print area. Each has its own fix in Excel — and one common cause. How to save each Excel sheet as its own PDF Excel has no one-click option for this. Export sheets one at a time, or run a short VBA loop over the worksheets. Here is the macro, and the honest note on when you want something else. How to turn a CSV into a clean PDF table A CSV carries no layout at all, so converting one really means laying it out. Open it in Excel and set page setup by hand, or drop the .csv into a converter whose engine does the layout for you. The PDF does not match Excel's print preview — why Excel paginates against the current printer driver, so preview and PDF can disagree and the same file can break differently on another machine. Lock paper size and scaling, or paginate independently.

Try it on the file that is giving you trouble

The browser converter takes one workbook and hands back the PDF. It is free, there is no signup, and your file is deleted after the conversion. The Windows desktop app adds whole-folder batch and needs Excel 2016 or newer.

Convert free