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

Saving workbooks in other commonly used file formats
When you click the Save As Type drop-down button in the Save As dialog box, Excel displays a long laundry list of file formats that you can choose from when saving the workbook file. You can use these file format options to instantly convert your worksheet data into another file format for use with applications other than Excel 2013.
Before saving a new workbook file in a non-Excel file format for use with another type of program (such as Web Page for the Internet, or PDF for the Adobe reader), be sure that you’ve first saved the spreadsheet data in a reg- ular Excel Workbook file. That way, you continue to have ready access to the data in Excel 2013 for the purposes of further editing, printing, and so forth without having to convert the new file back into a native Excel Workbook file format.
The most commonly used file format options include the following:
✦ Excel Workbook: Saves the workbook in the default Excel 2013 .xlsx file format.
✦ Excel Macro-Enabled Workbook: Saves the workbook in the default .xlsx file format with all macros (see Book VIII, Chapter 1) it contains enabled.
✦ Excel Binary Workbook: Saves the workbook in the binary file format optimized that enables faster loading of really large workbooks with tons of data.
✦ Excel 97-2003 Workbook: Saves the workbook in the .xls file format used by earlier versions of Excel 97 through Excel 2003 — note that an alert dialog box appears if Excel finds any features used in the workbook that aren’t supported in this file format.
✦ XML Data: Saves the workbook in an XML (Extensible Markup Language) format (using the .xml filename extension) often used to exchange lists of data over the Internet.
✦ Single File Web Page: Saves the workbook in an MIME HTML (Multipurpose Internet Mail Extension Hypertext Markup Language) with the .mhtm or .mhtml file extension. This special HTML format is used by some web browsers (mainly Internet Explorer) to mimic the work- sheets in the original workbook through the use of tabbed pages in the resulting web page.
✦ WebPage:SavestheworkbookinanHTML(HypertextMarkupLanguage) used to render all the data on all worksheets in the workbook in a single continuous web page with the .htm or .html filename extension.
Saving the Data 119
Book II Chapter 1
Building Worksheets