Page 526 - Excel 2013 All-in-One For Dummies

508 Exporting Workbooks to Other Usable File Formats
2010 or in the older binary file format (with the .xls filename extension) used in versions 97 through 2003.
It’s hard to imagine a co-worker or client getting by without Excel 2013, but it does happen. For those rare occasions, you can export your Excel workbook to one of three usable file formats for opening and printing with readily avail- able software programs that support them:
✦ PDF files for opening with Adobe Reader or Adobe Acrobat
✦ XPS files for opening with the XML Paper Specification Viewer or newer
web browser such as Internet Explorer 7
✦ HTML files for opening with all types and versions of web browsers
When converting an Excel workbook to one of these other file formats, you can either change the file type in the Save As dialog box when using the File➪Save As command, or you can export them from the Export screen in the Backstage view by using the File➪Export command.
Saving and exporting worksheets as PDF files
The PDF (Portable Document File) file format, developed by Adobe Systems Incorporated, enables people to open and print documents without any access to the original programs with which the documents were created. All they then need installed in order to be able to open and print the worksheet- as-PDF file is a copy of Adobe Reader (a free download from www.adobe.com) or a copy of Adobe’s Acrobat software.
Excel 2013 enables you to save your workbook files directly in this special PDF file format. To save a workbook as a PDF file, choose File➪Save As (Alt+FA), select the place where you want to save the new PDF file in the Save As screen, and then select PDF from the Save as Type drop-down list.
You can modify the filename and the drive and folder in which the new PDF file is saved and change any of the following options added to the bottom of the Save As dialog box:
✦ Standard (Publishing Online and Printing) following Optimize For (that is selected by default) or Minimum Size (Publishing Online) option buttons to compress the resulting PDF document for use on the web
✦ OpenFileafterPublishingcheckbox(selectedbydefault)tohaveExcel automatically open the new workbook saved as PDF file in your copy of Adobe Reader or Acrobat
✦ Options button to open the Options dialog box where you can select the part of the workbook or worksheet to publish and choose to not have the document properties and accessibility tags included in the resulting PDF file