Datasheet

126
PART II
■
GETTING THE DATA IN
To use a named formula in a cell, type = and the formula name (as
shown in Figure 4.21). If the formula is complex and you use it more
than once a year, naming it saves a lot of time.
Figure 4.21. Using a named formula in a cell
Edit names
Regardless of the method by which you create a name, you can find it in
the Define Name dialog box. Sometimes I want to edit a range name just
to add an extra row or column; instead of deleting the existing name and
naming the new range, I take the fast route and edit the existing name.
To edit a name, choose Insert

Name

Define. In the Define Name
dialog box, shown in Figure 4.22, click the name you want to edit in the
Names in workbook box, and edit the reference, formula, or constant
value in the Refers to box. Press Enter (not Close).
Be careful not to disturb the exclamation point (!), dollar sign ($), or
colon (:) marks or you’ll break the name and probably have to delete
and re-create the name.
Delete names
You must use the Define Name dialog box to delete names, and lest you
think this is unnecessary, I dare you to try to figure out what’s going on in
Inside Scoop
You won’t see formula or constant names in the Name box or the Apply Names
dialog box, but you can type them in formulas (so use easily remembered
names).
Inside
Scoop
Hack
If you want to keep a name definition but change the name, you must add the
new name and delete the old. The safest way is to select the old name and type
a different name in the Names in workbook box, then click Add, then select the
old name and click Delete.
09_763217 ch04.qxp 1/18/06 11:23 PM Page 126