Converting Excel to PDF should be simple. In practice, it's one of the most reliably frustrating document tasks out there. The spreadsheet looks perfect on screen, then the PDF comes out with columns cut off at the right edge, tables split across awkward page breaks, and row headers missing from pages 2 onward.
This happens because spreadsheets are designed to scroll infinitely, while PDFs are fixed-size pages. The conversion has to make decisions about where to cut the content — and those decisions are often wrong by default.
Before You Convert: Set Up Your Spreadsheet
The single most important thing you can do for a good Excel-to-PDF conversion is set up the print/page layout correctly in Excel before converting. This applies even when using an online converter like PDF Bolt.
Set a Print Area
In Excel: select the cells you want to include → Page Layout tab → Print Area → Set Print Area. This tells the converter exactly what to include and nothing more.
Choose Page Orientation
Landscape orientation (horizontal) works better for wide spreadsheets. Portrait for tall, narrow ones. Page Layout → Orientation.
Scale to Fit
Page Layout → Scale to Fit → set Width to "1 page" to force all columns onto a single page width. This prevents the most common problem of columns being cut off.
Freeze Row Headers
If your spreadsheet is tall (multiple PDF pages), set the title row to repeat on every page: Page Layout → Print Titles → Rows to repeat at top.
How to Convert Excel to PDF with PDF Bolt
Step 1 — Prepare Your Excel File
Following the steps above, set up your print area and page layout in Excel first. Save the file.
Step 2 — Upload to PDF Bolt
Go to the Excel to PDF converter and upload your .xlsx or .xls file.
Step 3 — Review the Output
Download and open the PDF. Check that all columns are visible, page breaks fall in sensible places, and the data is readable. For large spreadsheets, check multiple pages.
Common Conversion Problems and Fixes
| Problem | Cause | Fix |
|---|---|---|
| Columns cut off on right | Page too wide for A4/Letter | Landscape orientation + Scale to 1 page wide |
| Rows cut mid-data | No manual page breaks | Insert page breaks at logical boundaries in Excel |
| Formulas show as #REF or errors | Linked cells not in print area | Expand print area or replace formulas with values |
| Headers missing after page 1 | Print titles not set | Set "Rows to repeat at top" in Page Layout |
| Charts not appearing | Chart on separate sheet | Include chart sheet in conversion |
When to Use Excel-to-PDF
Convert Excel to PDF when:
- Sharing financial reports or data that shouldn't be edited
- Sending invoices generated from Excel templates
- Archiving spreadsheet data in a stable format
- Submitting reports to people who don't have Excel
Keep the Excel format when the recipient needs to work with the data, apply their own filters, or modify figures.
Frequently Asked Questions
Do Excel formulas transfer to the PDF?
Formulas are replaced by their calculated values in the PDF. The PDF shows the result, not the formula. This is usually what you want — it prevents others from reverse-engineering your calculations.
Can I convert multiple Excel sheets at once?
Upload the Excel file and all sheets will be included in the PDF as separate page sections (unless you've set a specific print area that targets one sheet).
What about Excel charts — do they convert?
Charts embedded within a sheet convert correctly. Charts on separate chart sheets may need to be selected specifically or copied into a regular sheet first.