Datasheet

10
Part I: Putting the Fun in Functions
At any given moment, one worksheet is always on top. In Figure 1-2, Sheet1
is on top. Another way of saying this is that Sheet1 is the active worksheet.
There is always one and only one active worksheet. To make another work-
sheet active, just click its tab.
Worksheet, spreadsheet, and just plain old sheet are used interchangeably to
mean the worksheet.
Guess what’s really cool? You can change the name of the worksheets.
Names like Sheet1 and Sheet2 are just not exciting. How about Baseball Card
Collection or Last Year’s Taxes? Well, actually Last Year’s Taxes isn’t too
exciting either.
The point is you can give your worksheets meaningful names. You have two
ways to do this:
Double-click the worksheet tab and then type in a new name.
Right-click the worksheet tab, select Rename from the list, and then type
in a new name.
Figure 1-3 shows one worksheet name already changed and another about to
be changed by right-clicking its tab.
Figure 1-3:
Changing
the name
of a
worksheet.
You can try changing a worksheet name on your own. Do it the easy way:
1. Double-click a worksheet’s tab.
2. Type in a new name and press Enter.
You can change the color of worksheet tabs. Right-click the tab and select Tab
Color from the list.
To insert a new worksheet into a workbook, click the Insert sheet tab, which
is located after the last worksheet tab. Figure 1-4 shows how. To delete a
worksheet, just right-click the worksheet’s tab and select Delete from the list.
05_568163-ch01.indd 1005_568163-ch01.indd 10 4/2/10 1:37 PM4/2/10 1:37 PM