Datasheet

Adding and Editing Data in a Workbook

Alternatively, sometimes you don’t want to permanently delete the sheet but instead just

want it out of view temporarily. Exercise 1.13 shows you how to hide worksheets and then

how to unhide them again.

Saving and Managing Workbooks

When you create a new workbook from scratch, you see in the title bar that Excel temporarily

names it Book1, Book2, and so forth. When you save this new workbook for the first time,

either by clicking the Save button on the Standard toolbar or by choosing Save from the File

menu, the dialog box that appears is named Save As. You can use this box to do three things:

1. Name the file.

2. Choose the location where you want to save it.

3. Choose the file type you want for this file.

However, in that same workbook, if you make more changes and then click the Save but-

ton, or choose File  Save, you will not see the Save As dialog box again. Instead, the file will

just be saved with the same name you first chose, in the same location and with the same file

type. The original file will be completely overwritten by the one you save the second time. The

original file will no longer be available; only the newer version with the changes will exist.

If instead you want to save the new version with a different name, or in a different location,

or as a different type, you must use File  Save As.

Though you can create folders in the Windows Explorer or My Computer windows, Exer-

cise 1.14 will show you how to use Excel to manage your files and folders in an orderly fash-

ion, which is one of the MOS objectives you could be tested on. The exercise also introduces

EXERCISE 1.13

Hiding and Unhiding Sheets

1. Click the 1st Qtr Sales sheet tab in Exercise 1-1.xls.

2. From the Format menu choose Sheet  Hide. The sheet tab no longer appears.

3. Repeat step 2 to hide the 2nd Qtr Sales, 3rd Qtr Sales, and 4th Qtr Sales sheets.

4. To unhide sheets, select Format  Sheet  Unhide.

5. A list appears that shows all your hidden sheets. Choose one and click OK to bring that

sheet back into view.

6. Repeat steps 4 and 5 until all sheets are unhidden.

7. Leave the workbook open for the next exercise.

4002book.fm Page 27 Friday, March 24, 2006 11:36 PM