Return to: What's New in Excel 2010.
One of the new features in Excel 2010 is the ability to convert Excel files to PDF format. A PDF file (Portable Document Format) allows others to view documents without needing the original program - like Excel installed on their computer. Instead, users can open the file with a free pdf reader program.
A PDF file also allows you to let others view data in a spreadsheet, without giving them the opportunity to change it.
Convert Excel Files to PDF Using the Save and Send Option
There are several methods for converting Excel files to PDF format in Excel 2010. In this tutorial we will look at using the Save and Send option located under the File tab of the ribbon.
The Save and Send option gives you two choices for creating a PDF document:
- Save all or a portion of a workbook in PDF format.
- Email a copy of the entire workbook without saving it first.
Email Excel Files in PDF Format
Note: You must have an email program, such as Microsoft Outlook, installed on your computer for this option to work.
- Open an Excel file that you want to send via email in PDF format.
- Click on the File tab of the ribbon to view the available menu options.
- Click on Save and Send in the File menu to view the options available.
- Click on Send Using E-mail under the Save and Send options.
- Click on the Send as PDF button on the right hand side of the window.
- Excel will open a new email message window. A copy of your workbook will be attached to the message in PDF format
- All pages of the workbook will be added to the pdf file. If you wish to exclude one or more worksheets of the workbook before converting it to pdf format, hide the worksheets you don't want to send before following steps 2 to 6 above.
- Complete the To line in the email message.
- Send the message.