Datasheet

127
CHAPTER 4
■
WORKING DATA MAGIC WITH CALCULATIONS
a workbook with lots of formulas and 85 named ranges, many of them
duplicates! (I had to do that for a client once, and it was not fun.) Names
live on long after the data is deleted.
To delete a name, choose Insert

Name

Define. In the Define
Name dialog box, click the name you want to delete and click Delete,
then click OK or Close (either button works).
Figure 4.22. Edit a name in the Define Name dialog box.
Using names in formulas
To use a name in a formula, type the name wherever the formula calls for
the cell or range reference (see Figure 4.23). If you used at least one capital
letter in the name (a very good idea), you can type the name in lowercase let-
ters. When Excel recognizes the name, the letters are switched to their origi-
nal capitalization. If you misspell the name, Excel won’t recognize it. You get
an error, and the lack of capitalization tells you that the name is misspelled.
Figure 4.23. Type the name in place of a reference in a formula.
Select the name
Edit the name
’
s reference
09_763217 ch04.qxp 1/18/06 11:23 PM Page 127