The quickest way to save Excel as PDF
Open your Excel file, then go to File > Save As. In the dialog box that appears, click the dropdown menu next to "Save as type" and select PDF. Choose where you want to save the file, name it, and click Save. Excel converts the spreadsheet to PDF format and stores it on your computer in that location.
This method works the same way in Excel for Windows and Excel for Mac. The PDF will look exactly as your spreadsheet appears on screen — all formatting, colors, and cell borders stay intact. If you only want to save part of your spreadsheet, you can select those cells before opening Save As, then check the "Selection" option in the PDF dialog.
Key Takeaways
- Use File > Save As, select PDF from the file type dropdown, and click Save to convert your spreadsheet in one step.
- Your PDF will match what you see on screen, including all formatting, fonts, and cell layout.
- You can save just a selected range of cells instead of the entire sheet by highlighting them first and choosing "Selection" in the save dialog.
- Excel creates a separate PDF file without changing your original Excel file — both versions exist on your computer afterward.
Saving a single sheet versus the entire workbook
By default, Excel saves only the sheet you are currently viewing when you use Save As with PDF. If your file has multiple sheets and you want all of them in one PDF, you need to tell Excel before you save. In the Save As dialog, look for an option that says Options or Settings (the exact wording varies by Excel version). Click it and check the box for "Entire workbook" or "All sheets."
If you forget to check that box, you will end up with a PDF of just the active sheet. You can always go back and save again with the full workbook selected. Some people prefer this — they save each sheet as its own PDF file so they can share or print them separately.
Adjusting page layout and margins before you save
Excel's default page setup might not match how you want your PDF to look. Before you save, click File > Page Layout (or Page Setup on Mac) to adjust margins, paper size, and orientation. If your spreadsheet is very wide, you can switch to landscape mode so it fits better on the page. You can also set scaling to shrink the content so it all fits on one page, or let it spread across multiple pages.
These changes only affect how the PDF looks — they do not change your original Excel file. Once you have the layout the way you want it, proceed to File > Save As and select PDF. The PDF will use the page settings you just configured.
Handling large spreadsheets and print areas
If your spreadsheet is very large, Excel might split it across many PDF pages in a way you do not want. You can control this by setting a print area before you save. Highlight the cells you want to include, then go to File > Print Area > Set Print Area. Now when you save as PDF, only that range will be included.
Another option is to use the Page Break Preview mode to see exactly where Excel will split pages. Go to View > Page Break Preview and you will see blue lines showing page boundaries. You can drag these lines to adjust where pages break, then save as PDF. This is especially useful if you have a report or table that needs to stay together on one page.
Saving as PDF from Print instead
Excel also lets you save as PDF through the Print dialog. Go to File > Print, and in the printer dropdown at the top, select Save as PDF or Print to PDF (the exact name depends on your operating system). This route gives you a preview of how the PDF will look before you finalize it. You can see page breaks, margins, and scaling all at once.
This method is useful if you want to double-check the appearance before saving. After you review the preview, click the button to save (usually labeled Save or Print), choose your location and filename, and you are done. Both the Save As method and the Print method produce the same PDF — choose whichever feels more natural to you.
Protecting your PDF with a password
Excel does not add password protection when it saves to PDF, but you can add it afterward using free tools. On Windows, right-click the PDF file, select Open with, and choose an app like Microsoft Edge or your default PDF reader. Many PDF readers have a "Protect" or "Encrypt" option in their menu. On Mac, you can open the PDF in Preview, go to Tools > Encrypt, and set a password.
If you need password protection built into the save process, you can use third-party PDF software like Adobe Acrobat Pro or free alternatives like PDFtk. These programs let you add security when you create the PDF. For most everyday use, though, saving the PDF and then protecting it separately works just fine.
Frequently Asked Questions
Will the PDF look exactly like my Excel file?
The PDF will match what you see on screen in Excel, including all colors, fonts, and cell borders. However, some Excel features like formulas and hyperlinks may not work the same way in PDF — formulas will show their results as static numbers, and hyperlinks may not be clickable depending on your PDF reader.
Can I edit the PDF after I save it?
PDFs are meant to be read-only files, not edited. If you need to make changes, edit the Excel file first, then save it as PDF again. Some PDF readers let you add comments or highlight text, but you cannot change the actual content the way you can in Excel.
What if my spreadsheet has charts or images?
Charts and images save into the PDF just like they appear in Excel. They will be positioned exactly where they are in your spreadsheet. Make sure they are not overlapping cells you want to include, or they might cover important data in the PDF.
Does saving as PDF delete my Excel file?
No. Saving as PDF creates a new file — your original Excel file stays on your computer unchanged. You will have both the .xlsx file and the .pdf file after you save.
How do I save just one column or row as a PDF?
Select the column or row you want, then go to File > Save As. In the dialog, look for an option that says "Selection" and check that box. Excel will save only the cells you highlighted into the PDF.