How to Convert Excel to PDF: Keep Your Formatting Perfect
May 10, 20265 min read
The Problem With Excel to PDF Conversion
If you've ever tried converting an Excel spreadsheet to PDF using "Save As PDF" in Excel, you've likely encountered these issues:
Columns cut off: Wide spreadsheets get split across multiple pages
Tiny text: Excel shrinks everything to fit, making it unreadable
Awkward page breaks: Rows get split between pages in the middle of data sections
Headers missing: Column headers don't repeat on subsequent pages
Charts not included: Some conversion methods skip charts and graphs
These problems happen because Excel's PDF export tries to map a potentially infinite spreadsheet canvas onto fixed-size pages. The results are often disappointing.
Method 1: Use an Online Converter (Recommended)
Online converters like PDFTools handle the formatting automatically:
Upload your Excel file: (.xlsx, .xls, or .csv)
Click "Convert to PDF"
Download: the formatted PDF
Our converter creates clean tables with:
Bolded header rows for easy scanning
Cell borders for clear data separation
Automatic column width distribution
Multi-sheet support with sheet labels
Automatic pagination for long spreadsheets
Method 2: Excel's Built-in PDF Export
If you have Microsoft Excel:
Go to File → Save As (or Export)
Choose PDF as the format
Click Options to configure page layout
Select "Entire Workbook" or "Active Sheet"
Click Save
Fixing Common Issues in Excel Before Exporting
Wide spreadsheets getting cut off:
Go to Page Layout → Orientation → Landscape
Or go to Page Layout → Scale to Fit → Width: 1 Page
Preview with File → Print Preview before exporting
Headers not repeating:
Page Layout → Print Titles → Rows to repeat at top
Method 3: Google Sheets
Open your spreadsheet in Google Sheets
Go to File → Download → PDF Document
Configure page size, orientation, and scaling
Click Export
Google Sheets' PDF export is more reliable than Excel's for simple spreadsheets, but it handles complex formatting (conditional formatting, sparklines) less well.
Formatting Tips for Best Results
Before Conversion
Remove empty rows and columns: Blank areas create wasted space in the PDF
Set column widths appropriately: Narrow columns for short data (dates, IDs), wider for descriptions
Freeze headers: This helps some converters identify header rows
Use consistent formatting: One font, one size for data cells creates a cleaner PDF
Check print area: Set a specific print area if you don't need the entire sheet
Choosing the Right Page Orientation
Spreadsheet Width
Recommended Orientation
1-5 columns
Portrait
6-10 columns
Landscape
11+ columns
Landscape with scaling, or split into sections
Handling Multi-Sheet Workbooks
When converting a workbook with multiple sheets:
Our online tool converts all sheets, each labeled with the sheet name
Excel's export gives you the option to include all sheets or just the active one
Consider whether all sheets are needed — excluding irrelevant sheets keeps the PDF focused
When Excel to PDF Isn't the Best Option
Sometimes a different format is more appropriate:
Need to share editable data?: → Share the Excel file directly or use Google Sheets
Need a quick visual?: → Take a screenshot or export as image
Need specific pages printed?: → Use Print Area in Excel before exporting
Need data for a database?: → Export as CSV instead
Conclusion
The key to great Excel-to-PDF conversion is preparation. Clean up your spreadsheet, set appropriate column widths, and choose the right page orientation before converting. For the fastest path to a clean PDF, use an online converter that handles formatting automatically.
Ready to try it?
Use our free tool — no signup, no watermarks, no limits.