The Most Common Excel to PDF Problem
You open what should be a clean PDF of your spreadsheet and find that columns are cut off at the edge, rows flow onto unexpected pages, and your perfectly formatted table is split across three pages in completely wrong places. This is the number one frustration with Excel to PDF conversion — and it is entirely preventable with a few minutes of setup.
Preparing Your Excel File for Perfect PDF Output
Before converting, apply these settings in Excel to get a clean result:
- Set the Print Area: Select the cells you want included (not the whole sheet), then go to Page Layout → Print Area → Set Print Area. This tells the converter exactly what to include.
- Scale to Fit Width: Go to Page Layout → Scale to Fit → Width: 1 page. This ensures all columns fit on one page width without being cut off.
- Set Page Orientation: For wide spreadsheets, go to Page Layout → Orientation → Landscape. Portrait orientation cuts off more columns.
- Narrow the Margins: Go to Page Layout → Margins → Narrow for maximum usable space.
- Freeze and Repeat Headers: If your spreadsheet is tall (many rows), go to Page Layout → Print Titles and set the header row to repeat on every page.
How to Convert Excel to PDF on ILoveConvert
- Set up your Excel file as described above and save it as .xlsx
- Go to ILoveConvert Excel to PDF
- Upload your spreadsheet
- Click Convert to PDF
- Download and review — check column widths, page breaks, and header repetition
What Gets Preserved in the Conversion
- Cell colours, borders, and fill formatting
- Bold, italic, and font size formatting
- Merged cells
- Charts and graphs (rendered as images)
- Formulas (displayed as their calculated values — not the formula itself)
- Column and row headers if set to print
- Page headers and footers defined in Page Layout
What May Look Different
- Custom fonts not installed on the conversion server will be substituted
- Conditional formatting with very complex rules may not fully render
- Interactive elements (dropdowns, buttons, macros) are removed — PDFs are static
- Sparklines (inline mini-charts) may not render in some versions
Dealing With Multiple Sheets
If your workbook has multiple sheets, the conversion typically includes the active sheet by default. To include all sheets, select all sheet tabs (click the first tab, hold Shift, click the last tab) before setting the print area. Alternatively, save each sheet as a separate file and merge the resulting PDFs using our Merge PDF tool.
Compressing the Result
Excel files with many charts and images can produce large PDFs. After conversion, run the file through our Compress PDF tool to reduce the size before sharing. A 5 MB Excel PDF with charts can typically be compressed to under 2 MB.