Change or delete a defined name
From MS OFfice Web Components Spreadsheet
Change or delete a defined name
- In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
- On the 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.