The Most Common Excel to PDF Problem
The biggest frustration with Excel to PDF conversion is the spreadsheet being cut off — data that fits fine on screen gets clipped at the page edge in the PDF. The reason is that Excel's on-screen view and its print settings use different page sizes and margins.
Before converting, a few minutes of setup in Excel makes a big difference in the result.
Setting Up Excel for Clean PDF Output
Set the print area: Select the cells you want to include, go to Page Layout → Print Area → Set Print Area. This tells Excel (and any converter) exactly which cells to include.
Use Fit to Page: Go to Page Layout → Scale to Fit and set Width to 1 page. This scales the sheet to fit horizontally on one page width, eliminating the most common cut-off issue.
Set page orientation: Wide spreadsheets often look better in Landscape orientation. Go to Page Layout → Orientation → Landscape.
Adjust margins: Narrow margins give you more space. Go to Page Layout → Margins → Narrow.
Converting Excel to PDF Online
- Set up your Excel file as described above and save it
- Go to ILoveConvert → Excel to PDF
- Upload your .xlsx file
- Download the PDF
The conversion uses LibreOffice on the backend, which handles complex Excel formatting including merged cells, conditional formatting, charts, and formulas displayed as values.
What Gets Preserved
- Cell formatting (bold, colors, borders)
- Merged cells
- Charts and graphs (as images)
- Formulas (displayed as their calculated values)
- Row and column headers if set to print
- Page headers and footers if defined
What May Look Different
- Custom fonts not installed on the conversion server (substituted)
- Conditional formatting with complex rules
- ActiveX controls and interactive elements (removed)
- Sparklines (small inline charts) may not render
Multiple Sheets
If your Excel file has multiple sheets, the conversion typically includes the active sheet or all sheets depending on your print settings. To convert all sheets, select all sheet tabs before setting the print area.
When to Convert Within Excel
If you have Excel installed, the built-in Save As PDF option (File → Save As → PDF) often gives the most accurate result because it uses Excel's own rendering engine. Use the online converter when you don't have Excel, are on mobile, or need to process files in bulk.
File Size After Conversion
Excel files with many charts and images can produce large PDFs. After conversion, run the result through the PDF compressor to reduce size for sharing. Typically, a 5 MB Excel file with charts becomes a 2–3 MB PDF, which can be compressed further to under 1 MB.