Datasheet

Save a Workbook in a
Different Format
1. Choose Office Button➪Save As. The Save As dialog box
appears.
2. Select the folder where you want to save the file from
the Save In drop-down list.
3. In the File Name text box, type a descriptive name for
the file.
4. Open the Save As Type drop-down menu. A list of file
formats appears.
5. Choose one of the 26 different file formats. Files saved in
the Excel 2007 format have a .xlsx extension, whereas files
created in earlier versions of Excel have a .xls extension.
6. Click Save. Depending on the format you choose,
Excel may prompt you for additional information.
Open an Existing Excel File
1. Choose Office Button➪Open. The Open dialog box,
seen in Figure 1-10, appears.
2. If necessary, select the appropriate folder from the Look
In drop-down list. Then select the file you want to open.
Open the Files of Type drop-down menu 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 a previous version of Excel, the words
Compatibility Mode appear on the title bar next to the document name.
Figure 1-9: Excel warns you of compatibility
conflicts.
Figure 1-10: Open a previously created Excel file.
Excel displays recently used files on the right side of the Office Button
menu. Click any listed filename to quickly open it.
➟
10
Chapter 1: Working with Excel Files
05_039212 ch01.qxp 12/29/06 10:42 PM Page 10