Convert 7 min read7 December 2024

How to Convert Excel to PDF

Try it free — no sign-up needed

Use PDF Mate's Excel to PDF tool directly in your browser.

Open Excel to PDF

Converting Excel to PDF is conceptually simple but comes with a specific problem that bites almost everyone the first time: wide spreadsheets. A spreadsheet that extends far to the right gets cut off in the PDF, leaving columns missing. Or the data gets squashed so small it's unreadable. Getting Excel-to-PDF right means dealing with this layout challenge — and it's worth knowing a few things before you send that financial report to a client.

The page layout problem with wide spreadsheets

A PDF page has fixed dimensions. A spreadsheet doesn't. When you have 15 columns that extend beyond one page width, the conversion has to make a decision: cut off at the page boundary (columns get missing), or shrink everything to fit (text becomes tiny). Neither is ideal for wide data.

The best solution is to handle the layout in Excel before converting. In Excel: Page Layout → Orientation → Landscape (this gives you significantly more horizontal space). Then Page Layout → Scale to Fit → set Width to 1 page. This tells Excel to fit all columns onto one page width while letting height extend to multiple pages. The result is usually much more readable than the default.

For genuinely large spreadsheets (20+ columns of data), sometimes the right answer is to split the report into multiple narrower views or export specific column ranges rather than the full sheet.

Converting with PDF Mate

Go to pdfmate.io/tools/excel-to-pdf. Upload your .xlsx or .xls file. The tool converts it to PDF preserving your Excel formatting, column widths, and data. Download the result.

If you have multiple worksheets in one workbook, check whether you need all sheets or just specific ones converted. The conversion typically processes the active sheet or all visible sheets depending on your settings.

Formatting that survives conversion

Cell formatting, borders, background colors, number formatting (currency, percentages, dates), conditional formatting visuals, and embedded charts all carry over to the PDF. What doesn't translate perfectly: complex custom chart types, some advanced chart effects, and ActiveX or macro-dependent elements (which are interactive in Excel but static in PDF, as expected).

Print area and gridlines

If you've defined a print area in Excel, the conversion will respect it — only the print area converts to PDF. This is useful for controlling exactly what appears. Gridlines by default don't show in PDF unless you've enabled "Print Gridlines" in Excel's Page Layout settings.

Quick answers

Can I convert multiple sheets at once? Typically yes — the conversion handles all visible sheets in the workbook, each becoming pages in the PDF.

Does the PDF preserve formula results? Yes — the PDF shows the calculated values, not the formulas themselves. The PDF is a snapshot of your data at the time of conversion.

What if the PDF looks different from Excel? Usually a print layout issue. Set page orientation, scaling, and print area in Excel before converting.

Convert your spreadsheet to PDF at pdfmate.io/tools/excel-to-pdf.

Ready to try it?

Free, browser-based, no sign-up required.

Open Excel to PDF