Datasheet

124
PART II
■
GETTING THE DATA IN
The Create Names dialog box
If the names you want to use are already headings in a table or labels for
specific cells (such as Total or TaxRate), the fastest way to name the cells
to which the labels refer is the Create Names dialog box. The Create
Names dialog box not only uses existing names (no typing), but it can also
create several names at once (for example, it can name all the columns in
a table using the table headings).
To name cells with the Create Names dialog box (shown in Figure
4.18), select the range you want to name (including the headings or
labels), then choose Insert

Name

Create. Select or deselect the
check boxes as needed so that the correct headings or labels are used,
and click OK.
Figure 4.18. The Create Names dialog box
The names are created, and you can select any of the named ranges
by clicking its name in the Name box list.
The Define Name dialog box
The Define Name dialog box is not a good choice for naming cells (it’s
too laborious), but it’s the only way you can name constant values and
formulas, edit the definition of an existing name, or delete a name.
To define a name for a constant value (for example, a tax rate),
choose Insert

Name

Define. Type the name (for example, TaxRate)
in the Names in workbook box (shown in Figure 4.19); then select and
delete everything in the Refers to box (including =), and type =your value
(for example, =0.75). Click OK (not Close).
09_763217 ch04.qxp 1/18/06 11:23 PM Page 124