How can I change what is in the "name box" in Excel?

  • Thread starter notexcellingtoogood
  • Start date
N

notexcellingtoogood

I am using the "name box" as an index for people's payment records. So all I
have to do is click on the name box and it brings up a list of all the
payment records I have on the worksheet in alphabetical order. The list uses
their addresses. The thing is, I can't change an address's name once I have
put it in the name box. Does anyone know how to make changes to material you
have entered in the "name box" of an excel worksheet? Having all the
addresses in the name box helps me to move around the worksheet much faster
than before when I didn't know how to use the "name box". Please help if you
can. Thanks.
 
R

Ron Coderre

Insert>Name>Define
Find the name you want to edit in the Names In Workbook list.

Note:
There is no editing a name (refers to:yes, the actual name:no)
So, first you'll create the correct name and then delete the erroneous one.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top