Microsoft Office Tutorials and References
In Depth Information
INSIDE OUT Hidden file name extensions revealed
File name extensions might not appear with Windows file names, depending on your
settings. To display file name extensions in Windows 8, click the File Explorer, click the
View tab, and select the File Name Extensions option. In Windows 7, click the Start
button, click Computer (Control Panel in Windows XP), click the Organize menu, select
Folder And Search Options and on the View tab, and then scroll down and clear the
Hide Extensions For Known File Types check box.
In addition to providing the file name and location, you can specify a different file format in
the Save As dialog box. Click the Save As Type drop-down list, which expands to reveal all
the formats in which you can save your files.
The default format is Excel Workbook (*.xlsx), and you’ll almost always use this option. If
you want to export an Excel file to another program, however, you can use one of the other
options to convert the file to a format that is readable by that program.
For more information about the Excel export formats, see “Importing and exporting text
files” later in this chapter.
Ensuring file compatibility with previous versions of Excel
When you open a workbook in Excel 2013 that was created in a previous version of Excel,
it automatically opens in Compatibility mode, a condition that is indicated in the Excel title
bar, as shown in Figure 2-25. You can always tell by looking at the title bar whether you’ve
converted a file to the new format.
Figure 2-25 Files created by any previous version of Excel open in Compatibility mode.
You can work normally with Compatibility mode, and when you save the file, it remains in
the old file format. If, however, you make any changes using features that are not
compatible with the older version, the Excel Compatibility Checker intervenes when you save and
displays a dialog box like the one in Figure 2-26.