Datasheet

128
PART II
■
GETTING THE DATA IN
You can type defined names in formulas as you write them, or in the
Function Arguments dialog box (covered in Chapter 5).
Paste names
If you can’t remember the name, or it’s a long name, you can use the
Paste Name dialog box to paste the name into the formula.
To paste names into a formula, start the formula, and place the inser-
tion point where you want to insert the name. Choose Insert

Name

Paste, click the name, and then click OK (see Figure 4.24).
If you don’t mind memorizing another keystroke, it’s faster to click in
the reference you want to replace with a name and then press F3 to open
the Paste Names dialog box.
Figure 4.24. Paste names instead of typing them.
Apply names
If you’ve already written formulas using normal cell references instead of
named cells, you can quickly change all the named cell references in a
worksheet into their names. Select the range of cells that contain formulas
Inside Scoop
If you want to remember what all of your names refer to without slogging
through the Define Name dialog box, you can paste a list of all the workbook
names and their definitions onto a worksheet. Click a cell, choose Insert

Name

Paste, and click the Paste List button.
Inside
Scoop
09_763217 ch04.qxp 1/18/06 11:23 PM Page 128