How to Convert Excel to PDF: Keep Formatting Perfect

Converting Excel to PDF should be simple, but formatting issues often ruin the result. Here's how to get it right.

Common Excel to PDF Problems

Print Area Issues

• Columns cut off at page edge
• Data split awkwardly across pages
• Empty pages included

Formatting Lost

• Column widths change
• Row heights inconsistent
• Fonts substituted

Page Layout Problems

• Portrait when you wanted landscape
• Wrong paper size
• Headers/footers missing

Method 1: Excel's Built-In Export (Best)

Step-by-Step:

1. Open your Excel file
2. File > Export > Create PDF/XPS
3. Choose location and filename
4. Click "Options" for settings:
5. Select sheets to include
6. Choose page range
7. Set quality
8. Click "Publish"

Alternative: File > Save As > PDF

Key Settings

What to Publish:
- Active Sheet(s) - Current selection
- Entire Workbook - All sheets
- Selection - Just highlighted cells

Page Range:
- All - Every page
- Specific pages - Enter range

Method 2: Print to PDF

Universal method that works:

1. Open Excel file
2. File > Print
3. Select "Microsoft Print to PDF" (Windows) or "Save as PDF" (Mac)
4. Adjust settings in print preview
5. Click Print/Save

Advantage: See exactly what you'll get in preview.

Method 3: Online Converter

When Excel isn't available:

1. Go to lexosign.com/excel-to-pdf
2. Upload your .xlsx or .xls file
3. Wait for conversion
4. Download the PDF

Best for: Quick conversions, any device, Google Sheets files.

Preparing Excel for Perfect Conversion

Step 1: Set Print Area

Define what should be included:

1. Select the cells you want in the PDF
2. Page Layout > Print Area > Set Print Area
3. Only this area will export

To clear: Page Layout > Print Area > Clear Print Area

Step 2: Adjust Page Breaks

Control where pages split:

1. View > Page Break Preview
2. Drag blue lines to adjust breaks
3. Avoid splitting tables mid-row

Tip: Keep related data on the same page.

Step 3: Set Page Orientation

Portrait vs Landscape:

1. Page Layout > Orientation
2. Choose Portrait or Landscape
3. Preview to confirm

Wide spreadsheets: Usually need Landscape.

Step 4: Adjust Margins

Fit more content per page:

1. Page Layout > Margins
2. Choose preset (Narrow fits more)
3. Or set custom margins

Step 5: Scale to Fit

Make content fit pages:

Page Layout > Scale to Fit:
- Width: 1 page (fits all columns on one page width)
- Height: Automatic or specific pages
- Scale: Percentage to adjust

Warning: Don't scale too small - text becomes unreadable.

Step 6: Add Headers/Footers

For professional documents:

1. Insert > Header & Footer
2. Add page numbers, dates, titles
3. Preview before exporting

Handling Multi-Sheet Workbooks

Export Specific Sheets

Hold Ctrl and click sheet tabs to select multiple:
1. Select desired sheets
2. Export as normal
3. Only selected sheets included

Export All Sheets

When using "Entire Workbook" option:
- Each sheet becomes separate pages
- Sheet names may appear as bookmarks
- Review each sheet's print settings first

Create Table of Contents

For large workbooks:
- Add a summary sheet first
- Include sheet names and descriptions
- Link to each section

Preserving Formulas Display

Showing Values (Default)

Formulas show their calculated results - this is usually what you want.

Showing Formulas

To document formulas:
1. Formulas > Show Formulas (Ctrl+`)
2. Export while formulas visible
3. Toggle back for normal view

Charts and Graphics

Embedded Charts

Charts within sheets:
- Export automatically with sheet
- Quality usually good
- Position maintained

Chart Sheets

Standalone chart sheets:
- Included when exporting workbook
- May need separate export for best quality

Images

Pictures in spreadsheet:
- Usually convert well
- Check resolution after conversion
- Large images may slow conversion

Protecting Data in PDF

Hide Sensitive Columns

Before converting:
1. Right-click column header
2. Select "Hide"
3. Export - hidden columns excluded

Use Print Area

Only include what should be shared:
1. Select safe data only
2. Set as print area
3. Export just the print area

Password Protect PDF

After conversion:
- Add password to PDF
- Restrict printing/copying if needed

Troubleshooting

"Columns Are Cut Off"

Solutions:
- Use Landscape orientation
- Decrease margins
- Scale to fit width
- Adjust column widths
- Set print area correctly

"Too Many Pages"

Solutions:
- Increase scaling percentage (carefully)
- Remove unnecessary blank rows/columns
- Set specific print area
- Adjust page breaks

"Fonts Look Different"

PDF embeds fonts, but:
- Unusual fonts may substitute
- Use standard fonts when possible
- Preview before sending

"Gridlines Missing"

To include gridlines:
- Page Layout > Sheet Options
- Check "Print" under Gridlines
- Or use borders on cells

"Headers Not Printing"

Check row repeat settings:
- Page Layout > Print Titles
- Set rows to repeat at top
- These appear on every page

Excel Online / Google Sheets

Excel Online

1. File > Save As > Download as PDF
2. Limited options compared to desktop
3. Consider downloading .xlsx first

Google Sheets

1. File > Download > PDF document
2. Set options in dialog
3. Or File > Print > Save as PDF

Batch Converting Multiple Files

For Many Excel Files

Online batch tools:
1. Upload multiple .xlsx files
2. Convert all at once
3. Download as ZIP

Scripting (Advanced)

Python with openpyxl or VBA macros can automate bulk conversion.

Conclusion

For perfect Excel to PDF conversion:

1. Prepare your spreadsheet - Set print area, page breaks, orientation
2. Use Excel's export - Best quality and control
3. Preview first - Catch issues before saving
4. Check the result - Verify all pages look correct

Convert Excel to PDF online - when Excel isn't available or for quick conversions.

Good preparation is the key to good results.