Datasheet

Building a table the semi-hard way

To create a table manually, what you typically want to do is enter the field

names into row 1, select those field names and the empty cells of row 2, and

then choose Insert➪Table. Why? The Table command tells Excel, right from

the get-go, that you’re building a table. But let me show you how this process

works.

Manually adding records into a table

To manually create a list by using the Table command, follow these steps:

1. Identify the fields in your list.

To identify the fields in your list, enter the field names into row 1 in a

blank Excel workbook. For example, Figure 1-3 shows a workbook frag-

ment. Cells A1, B1, C1, and D1 hold field names for a simple grocery list.

2. Select the Excel table.

Figure 1-3:

The start of

something

important.

Chapter 1: Introducing Excel Tables

05_045992 ch01.qxp 1/18/07 5:45 PM Page 13