CCNC/CCNC Module 4/Spreadsheets/Application/Subsection 6

Saving spreadsheets
So we have converted the template into a spreadsheet that contains actual data. Let's talk a bit about the essential features of the spreadsheet before we go any further. As we said earlier, the spreadsheet consists of rows and columns. The point at which a row intersects or cuts across a column is referred to as a cell. We will go into more detail about cells in Section 2. All data in the spreadsheet are contained in the cells and these data take the form of text, values or formulas. More on all three later. When you have entered data into your spreadsheet, you need to save it. If you dont, you will lose all that data, since you have been working on the template that is stored in RAM. As you know, RAM is volatile. If you switch off your computer, or if the power goes and the computer shuts down, you will lose everything. So you need to save your spreadsheet in a location where it will not get lost that easily. Below are instructions for saving your spreadsheet in different locations, under a different name and in different formats.

Now do it

Save on the hard drive of your computer


 * Click on File, then Click Save As. This will bring up the Save As dialogue.
 * Locate the directory in which you wish to save the file
 * Enter the name of the file in the File Name Window
 * Click Save

SCREENSHOT Save on a floppy disk or a memory stick


 * Click on File, then Click Save AS
 * Use the same procedure for saving on the hard disk

Save an existing file; save under another name

Sometimes we may want to have the same spreadsheet saved under a number of different names. Alternatively, we may want to save a spreadsheet before making changes. We would then have a copy of the new version as well as the version before changes were made. Suppose we have a spreadsheet loaded as shown below. In this case the spreadsheet already has the name demog.sxc.

SCREENSHOT

We can now save what is displayed on the screen in two ways:


 * 1) As the existing file: After loading demog.sxc from the hard disk, we made some changes to it. Those changes exist only on the version on the screen and will not automatically be made to the file that is located on the hard disk. To replace the version on the hard disk with the contents as displayed on the screen.


 * Click on File, then Save.


 * 1) Under another name: Suppose we do not want to overwrite the contents on disk but would still like to save what is on the screen.


 * Click on File, then Save as.

This will bring up the Save As dialogue. You use this in exactly the same way as you would if you were saving a completely new file.

Save in another file type Sometimes it is useful to convert the spreadsheet format into another format, for example, a text file that can be manipulated using a word processor. Alternatively, you may wish to save the spreadsheet in a format used by another spreadsheet program such as Microsoft Excel. To save a spreadsheet in a different format,


 * Click on File, then Save as
 * Click on the File Type Window. This will display a list of file types
 * Use the vertical scroll bar to view all the file formats.

The following table lists some of the main file formats and a brief explanation of each.

Save different Versions

On the file menu there is an option called Version that allows you to save different versions of the sp[readsheet in the same file. You are asked to give the version a name and this is recorded along with the date and time of the changes that were made. If you want to open another version of a file, simply click on File->Version and choose the Version you want to open.

(: This is a good place to introduce first Activity)