How to Convert an Excel Spreadsheet to PDF (and Keep the Formatting)

You hit File → Save As → PDF, open the result, and half your columns are missing. Or the chart that looked perfect on screen is now a pixelated mess. Or every worksheet exported as a separate file when you wanted one document. Excel-to-PDF has a reputation for being a two-click job that takes twenty minutes to actually get right.

The Quick Answer

The cleanest path is to use Excel itself: File → Export → Create PDF/XPS (or Save As → PDF on Mac and older versions). Before you click, open Page Layout → Page Setup and set Fit to: 1 page wide by [blank] tall. That single setting solves about 80% of the "my columns got cut off" problem.

If you don't have Excel — or you're working from Google Sheets, Numbers, or LibreOffice — every modern spreadsheet app has a built-in PDF export. The platform-specific steps are below.

Why the Default Export Goes Wrong

Excel doesn't actually know how wide your spreadsheet is until you tell it. By default, it treats your document like a long roll of paper and slices it into 8.5" × 11" sheets without caring whether a column gets split in half. That's why a 12-column budget spreadsheet often exports as a PDF with columns A–G on page 1 and columns H–L on page 4 — separated by your other worksheets and totally unreadable.

The fix isn't a different tool. It's three Page Layout settings you almost never touch:

1. Orientation — Landscape, for any spreadsheet wider than five columns.
2. Scaling: Fit to 1 page wide — Squeezes columns horizontally so nothing overflows.
3. Print Area — Tells Excel exactly which cells are part of the document. Without this, it'll happily include an empty 200-row tail.

Set those three things and your export will look almost identical to what's on screen.

Converting from Microsoft Excel (Windows or Mac)

1. Highlight your data and set the Print Area. Select the range you want exported, then Page Layout → Print Area → Set Print Area.
2. Fix the scaling. Page Layout → Scale to Fit, change Width to 1 page and leave Height set to Automatic.
3. Choose orientation. Landscape for wide sheets, portrait for tall ones.
4. Preview. Hit Ctrl+P (Cmd+P on Mac) to see the page breaks. Adjust scaling until everything fits.
5. Export. File → Export → Create PDF/XPS Document → Publish.

If you have multiple sheets in one workbook, the export dialog has an Options button — click it and select Entire workbook to put every sheet into a single PDF. By default Excel only exports the active sheet, which is the second most common Excel-to-PDF complaint.

Converting from Google Sheets

Google Sheets handles this slightly better than Excel because the export dialog shows a live preview.

1. File → Download → PDF (.pdf)
2. In the export pane, set Paper size (Letter or A4), Orientation (Landscape for wide sheets), and crucially: Scale → Fit to width.
3. Use Set custom page breaks if you need a section to start on a new page — Sheets won't auto-detect these.
4. Click Export.

The "Fit to width" option is the equivalent of Excel's "Fit to 1 page wide" — it's the setting that prevents columns from spilling onto extra pages.

Converting from Apple Numbers

Numbers makes you work harder than the other two. The export is hidden under File → Export To → PDF, and the formatting controls live in a different place:

1. View → Show Print View to see how your sheet will paginate.
2. Drag the blue page-break handles to set where pages split.
3. File → Export To → PDF, pick Good quality (Best produces huge files), and save.

Numbers tends to add generous white margins by default. If your PDF looks like it's floating on a sea of empty space, go to File → Page Setup and reduce the margins to 0.5" all around.

Converting from LibreOffice Calc

Calc is the most flexible of the four — its PDF export dialog is closer to a print driver than a one-click button.

1. File → Export As → Export Directly as PDF (the menu option labeled simply "Export as PDF" opens a complex dialog).
2. In Format → Page Style, set Scaling → Fit print range(s) to width/height: 1 by [blank].
3. Click Export and pick a filename.

If you need finer control — selective page exports, embedded fonts, PDF/A compliance — use the full Export as PDF dialog instead of the "Direct" option.

Common Problems and Fixes

Columns are cut off. You skipped the "Fit to 1 page wide" step. Go back and set it.

Charts look pixelated. Your spreadsheet contains rasterized images instead of native chart objects. In Excel, right-click the chart and confirm it shows "Format Chart Area" (native) rather than "Format Picture" (rasterized). Native charts export as crisp vectors.

Some rows are missing. Your Print Area is wrong, or there's a manual page break landing in an awkward spot. Page Layout → Breaks → Reset All Page Breaks, then re-set your Print Area.

Conditional formatting colors didn't carry over. Older PDF exports sometimes strip cell shading. Update to a current version of Excel, or print to PDF using your OS print dialog instead of the dedicated PDF export — the print path renders the document as if it were going to a real printer, which preserves all visual formatting.

The PDF is 40MB for a spreadsheet that's barely anything. Excel embeds full fonts and uncompressed images by default. Run the result through a Compress tool — a typical Excel-exported PDF drops 60–80% with no visible quality loss.

Multi-sheet export produced separate files. You didn't select "Entire workbook" in Excel's Options dialog. Or, if your tool doesn't support that, export each sheet individually and combine them with a Merge PDF tool.

When You Need to Send the PDF Securely

If you're emailing a spreadsheet with financial or HR data, the export itself isn't the last step. Excel-to-PDF leaves your data fully visible to anyone who opens the file. Use a PDF password protection tool before sending — it adds an open-password without re-exporting from Excel.

For documents that need a signature, save yourself the round-trip and skip the print-sign-scan flow. The E-Sign tool handles signatures inline on the exported PDF, which is faster and produces a cleaner final document than a scanned signature page.

Converting in the Other Direction

If you're trying to extract data from a PDF back into Excel (the opposite of this guide), that's a separate workflow. Native PDF tables generally extract cleanly, but scanned PDFs need OCR first. The PDF to Excel tool handles both cases — see how to convert PDF to Word without losing formatting for the broader extraction approach, which applies similarly to Excel output.

When You Need More

For people exporting spreadsheets to PDF dozens of times a week — accounting firms, financial analysts, anyone running monthly reports — a desktop tool like Adobe Acrobat Pro (adobe.com/acrobat.html) integrates directly with Excel via an add-in tab. The export quality is functionally identical to the built-in path, but you get batch conversion, automatic table-of-contents generation, and tagged-PDF accessibility output without re-clicking through Excel each time.

For one-off conversions, you don't need it. Excel's built-in export is fine if you set the three Page Layout options correctly the first time.