Datasheet

The Excel table must include the row of the field names and at least one
other row. This row might be blank or it might contain data. In Figure 1-3,
for example, you can select an Excel list by dragging the mouse from cell
A1 to cell D2.
3. Choose Insert➪Table to tell Excel that you want to get all official right
from the start.
If Excel can’t figure out which row holds your field names, Excel displays
the dialog box shown in Figure 1-4. Essentially, this dialog box just lets
you confirm that the first row in your range selection holds the field
names. To accept Excel’s guess about your table, click OK. Excel re-
displays the worksheet set up as a table, as shown in Figure 1-5.
Figure 1-5:
Enter your
table rows
into nicely
colored
rows.
Figure 1-4:
Excel tries
to figure out
what you’re
doing.
14
Part I: Where’s the Beef?
05_045992 ch01.qxp 1/18/07 5:45 PM Page 14