“Save” and “Save As”

Once you enter data in Excel, save it.
The quickest way is to click on the “Save” button in the “Quick Access” Toolbar:

A second way is by clicking the “Office” button.

If you have made changes to an existing workbook, select “Save”, if it’s a new workbook, or if you want to save the existing workbook with a different name, choose “Save As”.
When you choose “Save As” it opens a dialog box.

By default, Excel will choose to save the file in the “My Documents” folder.

You can change this by clicking the downward pointing arrow next to the “Save in” box at the top of the dialog box and navigate to the folder of your choice.

Once the folder is selected give the file a name in the “Filename” box at bottom of the dialog.
In the bottom box “Save as type”, by default Excel will save it as Excel 2007 file (*.xlsx).
If you wish to use this file in older versions of Excel, you can pick Excel 97-2003 Workbook *.xls from the drop-down menu.

If you have used functions of “Excel 2007”, which are not supported in the previous versions of Excel, you get this message.

Click “Continue” if you do not really want these, select “Cancel”, and save the file as “.xlsx” file if you want to retain all the features.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats