Changing or removing names

You can easily change or remove a name assigned to a cell or range. Click on the cell to activate it or select the range, then choose the Range Name command from the Insert menu. In the "Range Name" dialog, use the Delete and Delete All buttons to delete as required. You can select and delete the named cells and ranges at will.

To rename a cell or range, click on it in the Ranges box in the Range Name dialog, and then click on the Name box. Delete the name by selecting it and then either using Del on the keyboard or right-clicking on your mouse and selecting Cut. Type in the new name and select the Add button. The new cell or range name will appear in the Ranges box. Note that the old name, which is now inactive, is still there. To erase this, select it and click on the Delete button.

See also:

Assigning names to cells and ranges