Microsoft Excel 2007

How to save your work in Excel 2007

Now that your spreadsheet is coming along nicely, you'll want to save your work. To save your spreadsheet using Excel 2007, do the following.

• Click on circular File button in the very top left of Excel 2007. This one:

When you click the File button, you'll see the File Operations dialogue box appear:

The File button used to be a file menu in previous versions of Excel. In Excel 2007, you perform all the File operations by clicking the button. Clicking Close, for example, will close the current Excel spreadsheet, but won't close down Excel itself. To close down Excel, click the "Exit Excel" button in the bottom right of this dialogue box.

If you want to open a recent Excel document, click its name under the Recent Documents heading. But to save your work, click the Save option. You will then see another dialogue box appear - Save As:

At the top of the dialogue box, you'll see this:

Save in means "Where would you like to save your spreadsheet?" In the image above, we're saving it to a folder called excel.

Notice the blue down-pointing arrow on the Save in drop down list. Click the arrow to reveal more locations:

Choose a new location from the list, if you prefer. The large white rectangle on the Save as dialogue box will then show you all the files already in the location.

When you're happy with your file location, type a name for your file in the area at the bottom of the dialogue box :

Notice the "Save as Type" box below the file name. The type is a XLSX file, and this is new to Excel 2007. The old ending was XLS. Excel 2007 can open older XLS files, but previous versions of Excel will struggle to open XLSX files.

Remember to save you work on a regular basis, by clicking the round File Operation button in the top left, and then the Save option. A quicker way is to just click the disk icon on the Ribbon:

Coming up shortly is a Review, so that you can test your new knowledge of Excel 2007. First though, you'll need to know about currency options.

< -- Change Cell Colour | Currency Symbols in Excel 2007 -->

<--Back to the Excel 2007 Contents Page

View all our Home Study Computer Courses