MrExcel Publishing
Your One Stop for Excel Tips & Solutions

changing or deleting cell name


Posted by Susan Gentry on November 14, 2001 2:13 PM

I have a spreadsheet with a named cell and I need to either delete or change the name of the cell, however when I go the the cell name box at the upper left hand corner of the window and type over the name I am trying to change and hit return, it always goes back to the name it had before. Any ideas?

Thanks


Posted by Aladin Akyurek on November 14, 2001 2:28 PM

Activate Insert|Name|Define.
Select unwanted names one by one & delete.
Click OK.

Now you can use the Name Box to input appropriate names.

Aladin

=========