The fastest way to export Excel to PDF

Open your Excel file and go to File > Save As. In the dialog box, change the file type dropdown from "Excel Workbook" to "PDF". Choose where you want to save the file, name it, and click Save. Excel converts the spreadsheet to PDF and stores it on your computer in the location you picked.

This method works in Excel on Windows, Mac, and the web version. The PDF will look almost identical to how your spreadsheet appears on screen — same fonts, colors, borders, and layout. If your Excel file has multiple sheets, Excel saves only the sheet you're currently viewing unless you change that setting before exporting.

Key Takeaways

  • Use File > Save As and select PDF from the file type dropdown to convert your spreadsheet in seconds.
  • By default, Excel exports only the active sheet, so switch to the sheet you want before saving if your file has multiple tabs.
  • You can print to PDF instead if Save As is not available, using File > Print and selecting "Print to PDF" or "Save as PDF" from the printer dropdown.
  • Excel preserves formatting, formulas display as their results, and the PDF file size is usually smaller than the original Excel file.

Exporting a single sheet versus the entire workbook

When you use Save As and pick PDF, Excel exports only the sheet that is currently active — the one with the highlighted tab at the bottom. If your workbook has three sheets and you're on Sheet1, only Sheet1 becomes a PDF. To export a different sheet, click its tab first, then go to File > Save As and choose PDF.

If you need all sheets in one PDF file, you have two options. The first is to repeat the Save As process for each sheet and combine the PDFs afterward using a free tool like ILovePDF or Smallpdf. The second is to print all sheets to PDF: go to File > Print, select Print All Sheets under Settings, then choose "Print to PDF" or "Save as PDF" from the printer dropdown instead of a physical printer. This creates one PDF with all your sheets in order.

Controlling what appears in your PDF

Before you export, check what will actually show up in the PDF. If your spreadsheet is wider than a standard page, Excel may split it across multiple pages or shrink the text to fit. To preview this, go to File > Print Preview. You'll see exactly how many pages the PDF will be and whether columns are cut off or squeezed.

If the layout looks wrong, you can adjust it before exporting. Go to Page Layout (or Layout on Mac) and look for Orientation — switch from Portrait to Landscape if your data is wide. You can also set Margins to Narrow to fit more on each page, or use Scale to shrink everything to a specific number of pages. Once the preview looks right, save as PDF.

If you only want to export part of your spreadsheet, select the cells or range you want first. Then go to File > Print, and under Settings choose Print Selection. Switch the printer to "Print to PDF" or "Save as PDF" and click Print. This exports only the cells you highlighted.

Using Print to PDF when Save As is not available

In some versions of Excel or on certain computers, the PDF option may not appear in the Save As file type dropdown. If that happens, use the Print method instead. Go to File > Print, and look at the printer dropdown at the top left. You should see an option like "Print to PDF", "Save as PDF", or "Microsoft Print to PDF".

Select that option, then click Print. A dialog box will ask where you want to save the PDF and what to name it. This method works just as well as Save As and produces the same result — a PDF file on your computer. The Print method also gives you more control over page breaks and scaling if you need it.

What happens to formulas and formatting in the PDF

When Excel converts your file to PDF, all formulas calculate and display their results as numbers or text — the PDF shows what you see on screen, not the formula itself. If a cell contains =SUM(A1:A10), the PDF will show only the total, not the formula. This is intentional: PDFs are meant to be read, not edited, so formulas don't transfer.

Formatting like bold text, colors, borders, and font sizes all carry over to the PDF. Merged cells, conditional formatting colors, and cell backgrounds appear in the PDF the same way they appear in Excel. However, some advanced features like data validation, comments, and hyperlinks may not work in the PDF — hyperlinks sometimes do transfer, but it depends on your Excel version and the PDF reader being used.

File size and compatibility after export

A PDF exported from Excel is usually smaller than the original Excel file, especially if your spreadsheet contains a lot of formatting or hidden rows and columns. The PDF file size depends mainly on how many pages it is and whether it contains images or complex layouts.

PDFs open in any web browser and any PDF reader — Adobe Reader, Preview on Mac, or built-in Windows viewers. Unlike Excel files, PDFs cannot be edited in Excel or accidentally changed by someone opening them. This makes PDFs useful for sharing reports, invoices, or data you want to keep in a fixed format. If someone needs to edit the data later, they would need the original Excel file, not the PDF.

Frequently Asked Questions

Can I export multiple Excel sheets into one PDF file?

Yes. Go to File > Print, select "Print All Sheets" under Settings, then choose "Print to PDF" or "Save as PDF" from the printer dropdown. This creates a single PDF with all sheets in the order they appear in your workbook. If you use Save As instead, it exports only the active sheet.

Why does my PDF look different from my Excel file?

Excel may have adjusted the layout to fit the page width. Check File > Print Preview before exporting to see how it will look. If columns are cut off or text is too small, go to Page Layout, change Orientation to Landscape, reduce Margins, or adjust Scale. Then save as PDF again.

Will formulas show up in the PDF?

No. The PDF displays only the results of formulas, not the formulas themselves. If a cell shows 150, the PDF shows 150 — not the =SUM() formula that created it. This is normal and expected for PDFs, which are meant to be read, not edited.

What if Save As doesn't show PDF as an option?

Use File > Print instead. Select "Print to PDF" or "Save as PDF" from the printer dropdown, then click Print. Name and save your file the same way. This method works on all Excel versions and produces the same PDF result.

Can someone edit a PDF I exported from Excel?

Not easily. PDFs are designed to be read, not edited. Someone could use specialized PDF editing software to change text or numbers, but it's not straightforward. If you need others to edit the data, send them the original Excel file instead of the PDF.