How to Convert Excel to PDF (Without Losing Formatting)

How to Convert Excel to PDF (Without Losing Formatting)

Converting a spreadsheet to PDF sounds like a one-click operation — and it is, once you know which settings matter. The challenge is that Excel files regularly produce PDF output with broken layouts: columns cut off at the page edge, data spilling onto extra pages, charts that don't render correctly, or tiny illegible text because the entire spreadsheet was shrunk to fit.

This guide covers every conversion method and the specific settings that produce professional-looking PDF output.

Why Excel-to-PDF Formatting Breaks

Excel spreadsheets are designed for infinite horizontal and vertical scrolling — there is no natural "page" boundary. When you convert to PDF, the tool has to decide how to break the spreadsheet into fixed-size pages, and the default decisions are often wrong.

Common problems:

• Columns cut off: Wide spreadsheets get split across pages, splitting rows mid-cell
• Tiny text: The tool shrinks everything to fit one page, making it unreadable
• Multiple pages for simple data: Landscape data converted as portrait creates unnecessary page breaks
• Charts missing: Embedded charts sometimes don't render or appear on separate pages
• Gridlines missing: PDF output may or may not include the cell gridlines visible in Excel

Method 1: AllPDFMagic Excel to PDF (Online, Free)

AllPDFMagic Excel to PDF converts .xlsx and .xls files to PDF with accurate formatting preservation.

1. Open the Excel to PDF tool
2. Upload your Excel file
3. Select which sheets to include (all sheets or specific ones)
4. Click Convert
5. Download the PDF

Works well for: Standard spreadsheets without complex macros or VBA. Supports .xlsx, .xls, and .csv formats.

Method 2: Save As PDF in Excel (Best Quality)

If you have Microsoft Excel installed, the built-in Save As PDF produces the most accurate output because Excel itself controls the rendering.

1. Open your file in Excel
2. Go to File → Save As (or File → Export → Create PDF/XPS on Windows)
3. Change the file type to PDF (.pdf)
4. Click Options to control what is included:
   • Entire workbook — all sheets
   • Active sheet — current sheet only
   • Selection — only highlighted cells
5. Click Save

Before converting, optimise your print settings:

• Go to Page Layout tab
• Set Orientation (Portrait or Landscape)
• Use Scale to Fit to control how many pages wide and tall the output should be
• Set Print Area to exclude empty rows/columns at the edges
• Check Print Preview (Ctrl+P) to see exactly how the PDF will look

Method 3: Google Sheets (Free, No Excel Required)

If you don't have Excel installed:

1. Open the Excel file in Google Sheets (free — upload directly to Google Drive)
2. Go to File → Download → PDF Document (.pdf)
3. A settings panel appears — configure:
   • Paper size: A4 or Letter
   • Page orientation: Portrait or Landscape
   • Scale: Fit to width, fit to height, or custom percentage
   • Margins: Normal, narrow, or none
4. Click Export

Google Sheets' PDF export is reliable for most spreadsheets and particularly good at handling wide tables when you set orientation to Landscape.

Excel to PDF: Method Comparison

Page Layout Settings That Matter

Setting Print Area

Excel often includes empty columns and rows beyond your actual data. If you don't set a print area, the PDF may include dozens of blank pages.

1. Select all cells containing your data (click top-left cell, Shift+click bottom-right)
2. Go to Page Layout → Print Area → Set Print Area
3. Now only the selected range will export to PDF

Fitting Wide Spreadsheets

For spreadsheets wider than a single page:

• Landscape orientation (Page Layout → Orientation → Landscape) fits more columns
• Scale to Fit: Set "Width" to 1 page and "Height" to automatic — this forces all columns onto one page width while allowing as many rows as needed
• Narrow margins: Reduce margins to squeeze more data per page

Repeating Headers on Every Page

For multi-page spreadsheets, repeat the header row on every page:

1. Page Layout → Print Titles
2. In "Rows to repeat at top," select your header row
3. Now every PDF page will start with your column headers

Frequently Asked Questions

Why do my Excel formulas show as errors in the PDF? PDF conversion captures values, not formulas. If a formula shows an error (#REF!, #VALUE!, etc.) in Excel, that error value will appear in the PDF. Fix the formula errors in Excel before converting.

Can I convert multiple Excel sheets to one PDF? Yes. In Excel's Save As PDF dialog, select "Entire Workbook" to include all sheets. In AllPDFMagic, upload the file and select all sheets for inclusion. Each sheet typically becomes a new page section in the output PDF.

How do I convert just one sheet from a multi-sheet workbook? In Excel: make that sheet the active sheet, then in Save As PDF select "Active Sheet." In AllPDFMagic: select only the desired sheet in the sheet selector before converting.

My Excel file has charts — will they appear in the PDF? Yes, charts embedded in the spreadsheet appear in PDF output. Ensure the chart is sized to fit within the print area before converting. Charts on separate "Chart sheets" appear as individual pages in the PDF.

The PDF looks fine on screen but prints poorly. Why? PDF screen rendering and print rendering can differ. After generating the PDF, do a print preview before printing. If print quality is poor, re-export with higher DPI settings if your conversion tool supports it, or use Excel's built-in Save As PDF which produces print-optimised output.

Convert Excel to PDF free →

Related guides:

• How to Convert PDF to Excel — the reverse conversion
• How to Compress PDF Without Losing Quality — reduce PDF size after conversion
• How to Merge PDF Files Free — combine multiple converted PDFs