Change or delete a defined name

Office Components Spreadsheet

Change or delete a defined name

  1. On the spreadsheet toolbar, click Commands and Options , and then click the Formula tab.
  2. Under Names, in the All names box, click the name you want to change or remove.
  3. 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.