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.
Sharing an Excel spreadsheet directly is often impractical: the recipient needs Excel installed, column widths may look different on their screen, formulas and references are exposed, and the file can be inadvertently altered. Converting to PDF solves all of these problems — you get a professionally formatted document that looks identical for every recipient, can't be accidentally modified, and prints exactly as intended. The challenge is getting Excel-to-PDF conversion right, because wide spreadsheets don't always fit neatly on standard page sizes. This guide covers how to do it well.
Why Excel-to-PDF Conversion Is Tricky
Excel spreadsheets don't have a fixed page size by design — they're infinite canvases that scroll right and down as needed. Converting to a format with fixed page dimensions (like A4 or Letter) requires the conversion tool to make decisions about how to fit potentially wide or tall data onto pages. Without careful setup, you'll get PDFs where tables are cut off mid-column, rows overflow onto unexpected pages, or wide tables span 15 pages sideways when they'd look better rotated to landscape on 2 pages. The conversion itself is straightforward; the preparation for conversion is where the work is.
Preparing Your Excel File for PDF Export
Set the print area. Excel lets you define a "print area" — the specific cells you want to include in the output. Select the cells you want (use Ctrl+Shift+End to find the data extent), then go to Page Layout → Print Area → Set Print Area. This ensures only relevant data appears in the PDF, not empty columns or rows beyond your data.
Choose the right page orientation. In Page Layout → Orientation, choose Portrait for tall, narrow tables and Landscape for wide ones. A financial summary with many months as columns almost always benefits from Landscape orientation.
Control how data fits on pages. Page Layout → Scale to Fit lets you specify that all columns should fit on one page wide (while allowing as many pages tall as needed), or that the entire data should fit on one page. "Fit all columns on one page" is a popular choice — it prevents tables from being cut off horizontally.
Set and preview page breaks. Use View → Page Break Preview to see where your data will be divided across pages. You can drag the blue dashed lines to adjust page breaks manually. Pay attention to logical break points — don't split a section of related data across pages if you can avoid it.
Format headers and footers. Insert → Header & Footer lets you add the document title, date, page numbers, or your company name in the header or footer of each page. This is especially valuable for multi-page spreadsheets where each page should be identifiable independently.
Set rows or columns to repeat on each page. For tables that span multiple pages, it's essential that column headers and row labels appear on every page. Page Layout → Print Titles lets you specify which rows and columns to repeat, so every page of a 10-page data table has the header row visible.
Step-by-Step: Converting Excel to PDF
Step 1: Prepare your Excel file as described above.
Step 2: Go to pdfmate.io/tools/excel-to-pdf.
Step 3: Upload your .xlsx or .xls file.
Step 4: Click "Convert to PDF." The conversion happens server-side using a PDF engine that respects Excel's print settings.
Step 5: Download the resulting PDF and review it carefully — check that all columns are visible, headers appear on each page, and page breaks are in logical locations.
Tips for Better Excel PDF Output
Hide unused columns and rows before converting. If your data is in columns A–M but the spreadsheet extends to column Z, hide the empty columns before converting to keep the PDF clean and compact.
Use consistent formatting. PDFs of spreadsheets look more professional when cells have consistent font sizes, the header row has a contrasting background, and currency/number formatting is applied uniformly. These formatting choices in Excel carry through to the PDF.
For charts, position them carefully. If your Excel file includes charts, make sure they're positioned clearly on the sheets and won't be cut off by page breaks.
Common Mistakes to Avoid
Not setting a print area, resulting in a 50-page PDF of mostly empty cells. Always define the print area to include only the data you need in the output.
Ignoring landscape orientation for wide tables. A table with 20 columns will never look good on a portrait page. Use landscape for wide data sets.
Forgetting to repeat header rows. A 15-page data table where only the first page has column headers is nearly unusable. Set print titles to repeat headers on every page.
Frequently Asked Questions
Will formulas be visible in the PDF?
No — the PDF shows the calculated values, not the formula text. This is usually desirable when sharing with external parties who don't need to see your calculation logic.
What if my Excel file has multiple sheets?
By default, some tools convert only the active sheet. If you need all sheets converted, check the tool's options or convert sheets individually and merge the resulting PDFs.
Can I convert an Excel file with charts and graphs?
Yes — charts embedded in Excel sheets are included in the PDF output at the position and size they appear in Excel.
Is the conversion done in my browser?
Excel-to-PDF conversion is handled server-side (via ConvertAPI) because it requires Excel's rendering engine to properly interpret spreadsheet formatting. Files are processed and deleted immediately.
Convert your Excel spreadsheet to a clean PDF at pdfmate.io/tools/excel-to-pdf.