Microsoft Office Tutorials and References
In Depth Information
You’ve entered the data that Sandra wanted in the worksheet. Before proceeding further,
she suggests that you save the file with the name “Dalton”.
To save the workbook:
1. Click File on the menu bar, and then click Save . The Save As dialog box opens with the
current workbook name, which is “Book1,” in the File name text box.
2. Navigate to the Tutorial.01\Tutorial folder included with your Data Files.
Trouble? If you don’t have the Excel 2003 Data Files, you need to get them before you
can proceed. Your instructor will either give you the Data Files or ask you to obtain them
from a specified location (such as a network drive). In either case, be sure that you make a
backup copy of your Data Files before you start using them, so that the original files will be
available on your copied disk in case you need to start over because of an error or problem.
If you have any questions about the Data Files, see your instructor or technical support per-
son for assistance.
3. Replace the default filename with Dalton , make sure that Microsoft Office Excel
Workbook is displayed in the Save as type list box, and then click the Save button. Excel
saves the workbook with the name “Dalton” and closes the Save As dialog box. The new
workbook name appears in the title bar of the Excel window.
Trouble? If your computer has been set up to display file extensions, the filename
“Dalton.xls” will appear in the title bar.
By default, Excel saves the workbook in Microsoft Excel Workbook format, and for
most of the work you will do in this text, you will use this file format. If you are creating a
workbook that will be read by applications other than Excel (or earlier versions of Excel),
you can save your workbook in a different file format by following these steps:
1. Open the Save or Save As dialog box.
2. Display the location in which you want to save the file, and enter a filename, if
3. Click the Save as type list arrow, and then select the file format you want to apply.
4. Click the Save button.
Figure 1-20 describes some of the file formats in which you can save your workbooks.
Some of the formats supported by Excel
Microsoft Excel 4.0, 5.0, 97, 2000, 2002 Workbook
Saves the workbook in an earlier version of Excel
Single File Web Page
Saves the workbook as a single Web page file
(MHTML file) that can be read by Internet Explorer
4.0 or later
Saves the workbook as a template to be used for cre-
ating other Excel workbooks
Saves the workbook in separate files that are used as
the basis for a Web site, in a format that is readable by
Saves the workbook as an XML document