How to Save as a PDF in Excel 2010

Excel files are great for comparing and organizing data, but you may encounter situations where someone you are working with either requests a PDF file, or your workflow dictates that a PDF file is more useful.

There are thrid-party applications that can generate and convert Excel files to the PDF file format, but Excel 2010 includes its own tools for generating PDFs from your existing worksheet.

So continue reading below to learn the steps needed to create a PDF from your Excel file.

As an Amazon affiliate, I earn from qualifying purchases.

How to Convert Microsoft Excel Files to PDF

This tutorial will show you how to convert either a single Excel worksheet to a PDF, or the entire workbook to a PDF. If you convert the entire workbook, each worksheet will be included as part of a single PDF file.

Step 1: Open the Excel file that you wish to convert to the PDF format.

Step 2: Click the File tab at the top-left corner of the window.

open the excel 2010 file tab

Step 3: Click the Save As option in the column at the left side of the window.

click the save as option

Step 4: Click the drop-down menu to the right of Save as type, then choose the PDF option.

select the PDF option from the file type list

Step 5: Click inside the File name field, then type the desired name for the PDF file.

enter a name for the PDF file

Step 6: Locate the Optimize for section of the window, then choose either the Standard or Minimum size option. If you want to keep the file size as low as possible, select the Minimum size option.

select either the standard or minimum size option

Step 7: If you just want to save the active sheet as a PDF, then you can click the Save button at the bottom of the window and your PDF file will open automatically. If you want to save the entire workbook as a PDF, click the Options button.

click the options button

Step 8: Click the Entire workbook option in the Publish what section of the window, then click the OK button.

select the entire workbook option

Step 9: Click the Save button at the bottom of the window to create your PDF file.

Now that you know how to save as a PDF in Excel 2010, you can use these steps to create those types of files from the spreadsheets that you are editing.

Are you looking for a program that will allow you to make PDF files from scratch, including forms? Adobe Acrobat is an immensely helpful program that can create, edit and convert a number of different files to the PDF format. Click here to learn more about Adobe Acrobat, read reviews and check pricing.

We have also written about how to convert Word files to PDF files as well.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy