Change or delete a defined name

Microsoft Office Excel 2003

Change or delete a defined name

  1. On the Insert menu, point to Name, and then click Define.
  2. In the Names in workbook list, click the name you want to change.
  3. Do one of the following:
    • Change the name
      1. Type the new name for the reference, and then click Add.
      2. Click the original name, and then click Delete.
    • Change the cell, formula, or constant represented by a name

      Change it in the Refers to box.

    • Delete the name

      Click Delete.