Change or delete a defined name

MS OFfice Web Components Spreadsheet

Change or delete a defined name

  1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
  2. On the toolbar, click Commands and Options , and then click the Formula tab.
  3. Under Names, in the All names box, click the name you want to change or remove.
  4. 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.