How to Convert Excel to PDF Without Losing Formatting

Spreadsheets are great for working with data but terrible for sharing it. Send a .xlsx file and the recipient needs Excel, might see broken formulas, and can accidentally edit your numbers. Converting to PDF locks the layout and makes the data viewable on any device.

The challenge: spreadsheets are inherently wider than a standard page. Here is how to convert without losing columns, truncating cells, or producing unreadable output.

Convert Excel to PDF online

Use the Excel to PDF converter:

1. Upload your .xlsx file — drag and drop or browse.
2. Preview the conversion — check that all columns, rows, and charts are visible.
3. Download your PDF — instant download, no watermark, no account required.

Common formatting problems (and fixes)

Columns cut off on the right

Wide spreadsheets often extend beyond the page boundary. The rightmost columns disappear.

Fix before converting:

• In Excel: File → Print → change orientation to Landscape.
• In Excel: Page Layout → Scale to Fit → set Width to 1 page.
• In Excel: reduce column widths or font size to fit more on one page.

Text truncated in cells

Long text in narrow cells gets cut off when exported as PDF.

Fix: Enable Wrap Text for cells with long content (Home → Wrap Text in Excel). This expands the row height to show all content.

Charts or images overlapping text

Floating charts and images may shift during conversion.

Fix: Anchor charts to specific cells (right-click chart → Format Chart Area → Properties → "Move and size with cells").

Multiple sheets not included

By default, some converters only process the active sheet.

Fix: Select all sheets you want to include before converting (Ctrl+click sheet tabs in Excel, or use "Entire Workbook" in print settings).

Gridlines missing

By default, Excel gridlines do not appear in the PDF.

Fix: In Excel: Page Layout → check Print under Gridlines.

Best practices for clean spreadsheet-to-PDF conversion

1. Set a print area. Select the data range you want to export, then Page Layout → Print Area → Set Print Area. This prevents blank pages and excludes scratch calculations.

2. Use Page Break Preview. View → Page Break Preview shows exactly where pages will break. Drag the blue lines to control pagination.

3. Freeze headers for multi-page spreadsheets. Page Layout → Print Titles → Rows to repeat at top. This prints the header row on every page of the PDF.

4. Remove unnecessary sheets. Extra sheets (notes, scratch work, raw data) add pages to the PDF. Delete or hide them before converting.

5. Check margin settings. Narrow margins give you more usable space. Page Layout → Margins → Narrow.

When Excel to PDF is the right choice

Frequently asked questions

Does the conversion preserve formulas?

No. PDF is a display format — it shows the calculated values, not the underlying formulas. Keep the .xlsx file if you need the formulas.

Can I convert multiple Excel files into one PDF?

Convert each file separately, then use Merge PDF to combine them into a single document.

Can I convert the PDF back to Excel?

Partially. Tools exist to extract tables from PDFs, but complex formatting, merged cells, and charts may not convert cleanly. Keep the original .xlsx.

Does it support .xls (old Excel format)?

The converter primarily supports .xlsx (Excel 2007+). If you have an older .xls file, open it in Excel or Google Sheets and re-save as .xlsx first.

What about Google Sheets?

Google Sheets has a built-in "Download as PDF" option (File → Download → PDF). For .xlsx files exported from Google Sheets, you can use the Excel to PDF converter.

---

More office converters: Word to PDF, PPT to PDF, Compress PDF, or browse all converters.