Microsoft Office Tutorials and References
In Depth Information
Saving a Workbook with Different Formats
Saving a Workbook with Different Formats
Excel is a versatile spreadsheet program that allows you to save your workbook in a vari-
ety of different formats—see the table on the following page for a complete list and de-
scription. For example, you might want to save your workbook as a web page that you
can view in a web browser. Or you can save a workbook in an earlier version of Excel
(97-2003) in case the people you work with have not upgraded to Excel 2013. If you save
a workbook to Excel 97-2003, some new features and formatting are converted to unedit-
able pictures or not retained. The 2007-2013 format is compatible with Office 2003, Of-
fice XP, and Office 2000 with a software patch. However, for best results, if you’re cre-
ating a workbook for someone with Excel 97 to Excel 2003, it’s better to save it with the
.xls file format. In addition to the new XML-based file format, Excel also allows you to
save a workbook in a binary file format (or BIFF12), which is based on the segmented
compressed file format. This file format is most useful for large or complex workbooks,
and optimized for performance and backward compatibility.
Save a Workbook with Another Format
Click the File tab, and then click Export .
Click Change File Type .
Click the file type you want.
Click the Save As button.
Search JabSto ::




Custom Search