Excel 2010 For Dummies
Book image
Explore Book Buy On Amazon

Microsoft Excel 2010 lets you save your workbook files directly in the PDF (Portable Document Format) or XPS (XML Paper Specification) file format. These formats enable people to open and print your Excel worksheets even if they don't have Excel installed on their computers.

Follow these steps to save an Excel 2010 workbook in PDF or XPS format:

Click the File tab and choose Save As.

Click the File tab and choose Save As.

The Save As dialog box appears.

In the Navigation pane, select the folder in which you want to save the file.

(Optional) If you want to save the workbook file inside a new subfolder within the folder currently open in the Save As dialog box, you can click the New Folder button on the toolbar and then type the name of the folder and press Enter.

Type a descriptive name for the file in the File Name box.

You can use the original name if you want so that your original Excel file will appear right next to the PDF or XPS file in an alphabetical list.

Click the Save as Type arrow and select either PDF or XPS Document.

Click the Save as Type arrow and select either PDF or XPS Document.

Excel displays additional options that apply to PDF and XPS files near the bottom of the Save As dialog box.

Beside the Optimize For heading, select Standard or Minimum Size.

Beside the Optimize For heading, select Standard or Minimum Size.

If you want to make the PDF or XPS file as small as possible (because your worksheet is large), select the Minimum Size (Publishing Online) option button.

(Optional) If you want to change which parts of the workbook are saved in the PDF or XPS file, click the Options button; then make the appropriate selections and click OK.

(Optional) If you want to change which parts of the workbook are saved in the PDF or XPS file, click the Options button; then make the appropriate selections and click OK.

From the Options dialog box, you can change how much of the worksheet to convert as well as including the document properties in the output.

Click the Save button.

Excel saves the workbook in the PDF or XPS file format that you selected in Step 4, and automatically opens the file in Adobe Reader or XPS Reader (unless you deselected the Open File After Publishing check box in the Save As dialog box).

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.

This article can be found in the category: