The quickest way: File menu to PDF export

Open your Excel file and go to File in the top left corner. Click File, then select Save As. A dialog box will open showing where your file will save and what name it will have.

In the dialog box, look for a dropdown menu that says File Format or Save as type — the exact wording depends on whether you use Excel on Windows or Mac. Click that dropdown and scroll down until you find PDF. Select it, then click Save. Excel will convert your spreadsheet to PDF and save it to the location you chose.

The PDF will look like your Excel sheet — same data, same layout — but as a static document that anyone can open and read without Excel installed.

Key Takeaways

  • The File menu's Save As option lets you pick PDF as your file format instead of the default Excel format.
  • Excel on Windows and Mac both have the PDF option in the Save As dialog, though the menu names differ slightly between versions.
  • A PDF copy preserves your spreadsheet's appearance but locks it so others cannot edit the data without special tools.
  • You can save a single sheet or the entire workbook as one PDF file depending on what you select before saving.

Choosing what to save: one sheet or the whole workbook

Before you click Save, decide whether you want to convert just the sheet you are looking at or every sheet in your workbook. If you only need one sheet as a PDF, make sure that sheet is the active one — the tab at the bottom should be highlighted — when you open the Save As dialog.

Excel will ask you to confirm: Save the active sheet only or Save the entire workbook. Pick whichever matches what you need. If you choose the entire workbook, Excel creates one PDF file with all your sheets in order, each on its own page.

Adjusting page layout before you save

Excel's default PDF export might split your data across multiple pages in ways you did not expect. Before saving, you can control how your sheet breaks across pages by going to Page Layout (or Layout on Mac) in the ribbon at the top.

Look for Print Area if you only want certain cells in the PDF. You can also use Page Break Preview to see where Excel will split pages and drag the blue lines to move them. Once your layout looks right, go back to File > Save As and export as PDF.

This step is optional — many people save without adjusting and the result is fine — but it prevents surprises like a single column ending up alone on page two.

Using Print to PDF on Windows

Windows 10 and later include a built-in PDF printer. Instead of using Save As, you can go to File > Print, then look for a dropdown that says Printer at the top. Click it and select Print to PDF or Microsoft Print to PDF.

Click Print and Windows will ask where to save your PDF file. This method gives you a preview of how the PDF will look before you finalize it, which some people find helpful. The result is identical to using Save As — both create a PDF file — so use whichever feels more natural to you.

What happens to formulas and hidden data

When you save an Excel file as PDF, formulas disappear and only the results show. If a cell contains a formula that calculates a total, the PDF will display the number but not the formula itself. This is intentional — PDFs are meant to be read, not edited or recalculated.

Hidden rows and columns also stay hidden in the PDF. If you hid certain data in Excel, that data will not appear in the PDF either. If you need hidden information to show up, unhide it before you save.

File size and sharing considerations

A PDF version of your spreadsheet is usually smaller than the original Excel file, especially if your sheet contains images or complex formatting. PDFs are also safer to share because they cannot be accidentally edited — the person who opens it sees exactly what you intended them to see.

However, if someone needs to work with your data — sort it, filter it, or add new rows — they will need the original Excel file, not the PDF. Use PDF when you are sharing a finished report or a document that should not change. Use the Excel file when you are collaborating or when the other person needs to modify the data.

Troubleshooting common problems

If the PDF looks wrong — text is cut off, columns are too narrow, or pages break in odd places — the issue is usually your page setup, not the PDF conversion itself. Go back to Page Layout and check your margins and print area. You can also try changing the page orientation from Portrait to Landscape if your data is wide.

If the Save As dialog does not show PDF as an option, you may be using an older version of Excel. Excel 2007 and later all support PDF export. If you are using something older, you can download a free PDF converter online, or upgrade to a current version of Excel.

Frequently Asked Questions

Can I edit a PDF after I save it from Excel?

Not easily. PDFs are designed to be read-only. You can use specialized PDF editing software to make changes, but it is much harder than editing the original Excel file. If you think you might need to change the data later, keep the Excel file and only use the PDF for sharing or archiving.

Will the PDF look exactly like my Excel sheet?

Usually yes, but page breaks and margins may differ slightly depending on your printer settings. The data and formatting stay the same. If appearance is critical, preview the PDF before you share it — use Print Preview or open the saved PDF file to check.

What if my Excel file has multiple sheets and I only want one as a PDF?

Click the sheet tab at the bottom to make it the active sheet, then use File > Save As. When the dialog appears, choose Save the active sheet only instead of the entire workbook. Only that one sheet will be converted to PDF.

Does the PDF file stay linked to the Excel file if I change it later?

No. The PDF is a separate, static copy. If you edit the Excel file after saving it as PDF, the PDF does not update automatically. You have to save it as PDF again to create a new version with the changes.

Can I password-protect a PDF I save from Excel?

Excel's built-in PDF export does not include password protection options. If you need a password-protected PDF, you can use third-party PDF software after saving, or look for password options in your printer settings when using Print to PDF.