Naming a Cell

[Zachary Kinning]

In Excel, how do you name a cell so that is shows up in the name box?

 

[Don Guillett]

seletct the cell and type in a name in the name box

or
sub namecell()
range("a2").name="name"
end sub

 

[FSt1]

hi
2003
select the cell, on the toolbar>insert>name>define
2007
on the formula tab, in the defined name group, click name manager.

Regards
FSt1

 

[Elkar]

The simple way:

Select your cell, then type the name you want for it directly into the Name
Box.

The longer way:

In Excel 2003:
Go to INSERT Menu
Select "Name" then "Define..."
Type in a Name
Type in or choose a cell reference
Click "Add" button

In Excel 2007:
Go to the FORMULAS Tab
Click on "Name Manager" button
Click "New" button
Type in a Name
Type in or choose a cell reference
Click OK

HTH
Elkar

 

[Rick Rothstein]

If you go with the "select the cell and type in a name in the Name Box"
solution, just remember that you must press the Enter key after typing the
name to lock it in (don't just click out of the Name Box)