Datasheet
Working with rows, column,
cells, ranges, and tables
A worksheet contains cells. Lots of them. Billions of them. This might seem
unmanageable, but actually it’s pretty straightforward. Figure 1-7 shows a
worksheet filled with data. Use this to look at a worksheet’s components.
Each
cell can contain data or a formula. In Figure 1-7, the cells contain data.
Some, or even all, cells could contain formulas, but that’s not the case here.
Columns have letter headers — A, B, C, and so on. You can see these listed hor-
izontally just above the area where the cells are. After you get past the 26th
column, a double lettering system is used — AA, AB, and so on. After all the
two-letter combinations are used up, a triple-letter scheme is used. Rows are
listed vertically down the left side of the screen and use a numbering system.
Name Box Formula Box
Rows Active Cell Columns
Figure 1-7:
Looking at
what goes
into a
worksheet.
Figure 1-6:
Eyeing the
Watch
Window.
13
Chapter 1: Tapping into Formula and Function Fundamentals
05_046555 ch01.qxp 12/26/06 7:54 PM Page 13