Microsoft Office Tutorials and References
In Depth Information
More About Cell Names
4
Select cell B8 to
deselect the
range D2:E6 and
then click the Name
box arrow in the
formula bar to view
the names created
(Figure 4–12a).
Name
Manager
button
Name box
arrow
Name
Manager
dialog box
How can the cell
names be used?
You now can use
the assigned names
in formulas to
reference cells in
the ranges C4:C6 or
E2:E6. Excel is not
case–sensitive with
respect to names
of cells. Hence, you
can enter the names
of cells in formulas
in uppercase or lowercase letters. To use
a name that is made up of two or more
words in a formula, you should replace any
space with the underscore character (_). For
example, the name, Down Payment, is written
as down_payment or Down_Payment when
you want to reference the adjacent cell C5.
Figure 4–12b shows the Name Manager
dialog box that displays when you click the
Name Manager button.
list of names
names created
displayed in
Name list
(a)
Excel automatically
inserts underscore in
names with two words
Close button
(b)
Figure 4–12
Other Ways
1. Select cell or range,
type name in Name box,
press ENTER key
2. Select cell or range, on
Formulas tab on Ribbon
click Defi ne Name
button, [type name],
click OK button
3. Select cell or range, on
Formulas tab on Ribbon
click Name Manager
button, click New, [type
name], click OK button,
click Close button
More About Cell Names
If you enter a formula using Point mode and click a cell that has an assigned name,
then Excel will insert the name of the cell rather than the cell reference. Consider these
additional points regarding the assignment of names to cells:
1. A name can be a minimum of 1 character to a maximum of 255 characters.
2. If you want to assign a name that is not a text item in an adjacent cell, use the
Defi ne Name button on the Formulas tab on the Ribbon (Figure 4–10 on the
previous page) or select the cell or range and then type the name in the Name box
in the formula bar.
3. Names are absolute cell references. This is important to remember if you plan to
copy formulas that contain names, rather than cell references.
4. Excel displays the names in alphabetical order in the Name list when you click the
Name box arrow and in the Name Manager dialog box when you click the Name
Manager button on the Formulas tab on the Ribbon (Figures 4–12a and 4–12b).
 
 
Search JabSto ::




Custom Search