With the worksheet you want to save open in the Excel window, open the File menu and select Save As to open the Save dialog box.
Click the My Documents icon or, if necessary, move through the folder structure to save the file where you want (My Documents is the default on most computers).
In the File Name field, type a descriptive name for the file. Then, click the Save button.
The Excel title bar now contains your workbook's name.
INTRODUCTION
Until you save the workbook in which you are working, the data in the file is not stored on disk. You should regularly save your workbooks as you work in them so you don't lose your work. Also, after you save a workbook, you can retrieve it later to work on.
TIP
Using Save In Options
If you don't want to save your file in the My Documents directory, you can select the Save in drop-down list box and maneuver through your folders to save the file in a different location.
TIP
Using the Save Button
If you have already saved and named your file, you can resave it after making additional changes by clicking the Save button on the Standard toolbar.