How to convert Excel to PDF

While Excel works well for calculations and data management, spreadsheets can appear differently depending on the device or software version being used. Columns may shift, pages can break incorrectly and recipients without Excel may have trouble opening the file. Saving your spreadsheet as a PDF keeps the layout consistent and creates a format that is easy to view, print and share.

This guide explains three reliable methods for converting Excel files to PDF. Each option helps preserve your spreadsheet’s formatting, layout and data. We’ll start with the quickest and easiest method first.

Method 1: Use Lumin's free Excel to PDF converter

The fastest way to convert an Excel file to PDF is with Lumin’s free Excel to PDF converter. It works directly in your browser, so there’s no need to download or install additional software. The tool converts your spreadsheet in seconds while keeping your formatting and layout intact.

Here's how to convert your file:

1. Open Lumin's free Excel to PDF converter and upload your .xlsx or .xls file.
2. Select "PDF Document" from the format dropdown menu.
3. Select "Save on your computer" or save the PDF directly to your Google Drive.

Note: The Lumin converter preserves your spreadsheet's formatting, including column widths, cell borders and number styles. It's ideal when you need a quick conversion without adjusting print settings manually.

Method 2: Use Microsoft Excel's built-in export

If your spreadsheet is already open in Microsoft Excel, you can convert it to a PDF directly from the application. This method is useful when you want more control over the page layout, print settings and formatting before saving the file. It also allows you to adjust the print area and preview how the final PDF will look.

Here's how to do it:

1. Open your spreadsheet in Microsoft Excel.
2. Go to "File" > "Export" > "Create PDF/XPS Document." 
3. Choose PDF from the "Save as type" dropdown.
4. Click "Options" to choose whether to save the active sheet, the entire workbook or a selected range.
5. Click "Save."

Method 3: Convert Excel to PDF with Google Drive

If you use Google Drive or Google Sheets, you can convert an Excel file to PDF directly in your browser. This method is convenient for sharing files online and works without installing Microsoft Excel.

Here’s how to do it:

1. Upload your Excel file to Google Drive.
2. Open the file in Google Sheets.
3. Click File then select Download → PDF (.pdf).
4. Adjust the layout, scaling and formatting settings if needed.
5. Click Export to save the PDF to your device.

How to convert Excel to PDF without losing formatting

Formatting issues are a common frustration when converting spreadsheets to PDF. Columns get clipped, text overflows and page breaks land in awkward spots. Here are a few tips to keep your layout intact:

• Set your print area first. In Excel, select the cells you want to include, then go to "Page Layout" > "Print Area" > "Set Print Area." This tells the PDF export exactly which content to capture.
• Adjust column widths and row heights. Make sure all data is visible within each cell. Hidden or overflowing text will be cut off or wrap unpredictably in the PDF.
• Use "Fit Sheet on One Page." In Excel's print settings, use the scaling option under "Page Layout" to shrink your spreadsheet to fit a single page. You can also access this through the print dialog when using Method 3.
• Switch to landscape orientation. Wide spreadsheets with many columns convert better in landscape mode. You can change this in Excel's page setup under the "Page Layout" tab.

Checking these settings before exporting saves you from repeated conversions and misaligned output.

Frequently asked questions

How do I convert Excel to PDF and fit everything on one page?

Before saving, go to "Page Layout" > "Page Setup" in Excel and set the scaling to "Fit Sheet on One Page." You can also select this scaling option directly in the print dialog when using Method 3. Switching to landscape orientation helps fit wide spreadsheets.

Can I convert multiple Excel sheets to a single PDF?

Yes. In Microsoft Excel, when you save as PDF, click "Options" and choose "Entire Workbook." This includes all sheets in one PDF file. You can also select "Entire Workbook" from the print settings if you're using Method 3.