Change or delete a defined name
Office Components Spreadsheet
Change or delete a defined name
- On the spreadsheet toolbar,
click Commands and Options ,
and then
click the Formula tab.
- Under Names, in the All names box, click the name you want to change or
remove.
- Do
one of the following:
- To change the name, type a new name in the Name box and
click Define. Then, click the original name in the All names
box and click Remove.
- To change the cell, formula, or constant represented by a
name, change it in the Refers to box,
and then click Define.
- To delete the name,
click Remove.