Datasheet

10
Chapter 1: Working with Excel Files
Figure 1-9
Figure 1-10
Save a Workbook in a Different Format
1. Click File and, from Backstage View that appears, choose Save
As. The Save As dialog box appears.
2. In the File Name text box, type a descriptive name for the file.
3. Click the drop-down arrow on the Save as Type drop-down
list to display a list of file formats.
4. Choose 1 of the 27 different file formats (see Figure 1-9).
Files saved in Excel 2010 or Excel 2007 format have an
.xlsx extension, whereas files created in earlier versions of
Excel have an .xls extension.
5. Click the Save button. Depending on the format you choose,
Excel may prompt you for additional information.
Open an Existing Excel File
1. Click File and from Backstage View that appears, choose Open.
The Open dialog box, as shown in Figure 1-10, appears.
From File, click Recent and then Excel displays recently used files in the middle column
of Backstage View. Click any listed filename to quickly open it.
2.
If necessary, select the appropriate folder from the folder
pane and then select the file you want to open.
Open the file type drop-down list to display files saved in other formats.
3.
Click the Open button. The workbook appears in the Excel
workspace, ready for you to edit.
If the file you open was created in Excel 2003 or an earlier version of Excel,
Compatibility Mode appears on the title bar next to the document name. (See the fol-
lowing section for more information.)
05_501641-ch01.indd 1005_501641-ch01.indd 10 4/23/10 8:59 PM4/23/10 8:59 PM