Change or delete a defined name

Office Web Components

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 Button image, 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.