Subtitles of the Movie

Whenever making changes to or creating new Excel workbooks, it's important that you save those changes. In this lesson we'll discover the various methods for saving workbooks in Excel. Let's say that we make a change to June's car payment on this worksheet. As soon as that change is made we'll make sure that its committed to memory by executing the save command. In the file menu, there are two such commands for committing changes to memory. The first is called save. Notice to the left of the word save, is a button that looks like a disc which will appear on the toolbar as well. To the right is a keystroke that will execute this command called control s. Use this command whenever you are simply trying to update a document in memory. Now that I've selected the save command, that 280 dollar amount will appear in the workbook anytime I open it. When you wish to change the name or location of a saved document, then you'll execute the "save as" command in the file menu. When I select save as a dialog box appears in the window. In the budgets folder I am currently working on the 1999 records document. That also appears down in the file name area. Since it's selected, let's say that I want to change the name of this document to 1999 financial statement. I can type over the current name, and I can also change the location of this document from the drop down box at the top. Let's move this to the d drive. At this point clicking the save button will put a copy of that file in the new location under the new name of 1999 financial statement. To show you this I'll minimize Microsoft Excel and open up My Computer where the documents are being stored. One in the d drive, called 1999 financial statement and the other in the budgets folder, called 1999 records. When saving a document for the first time these commands work slightly differently. I'll start a new document and enter some data into it. I now want to store this data, and to do so I can go to the file menu and select either of the two commands. Selecting save as usually brings up the dialog box. Selecting save will usually just commit changes to memory. But now as you can see, when I select just the save command, the save as dialog box appears. Since we've not yet given our document a name or a location and Excel needs these two things in order to commit the changes to memory. Let's say I want to call this file data, and I'd store it in the same budgets folder. Clicking save now actually creates that file in the computer's memory. So, when you start a new workbook, it doesn't matter weather you select save or save as, both will take you to the same place and allow you to choose a location and a name for your file. both will take you to the same place and allow you to choose a location and a name for your file.