Name Manager
- Tools › Formulas › Names
Lists every name defined in the workbook and what each one refers to, so you can check, change or remove them from one place.
- Click Name Manager.
- Find the name you want in the list.
- Edit what it refers to, or delete it.
- Close the dialog when you have finished.
Tip Deleting a name that formulas still use leaves them pointing at nothing, so check before you remove one. A name that cannot be accepted does not close the dialog: the reason appears below the fields. A name shown in red is one Excel would remove when opening the file: select it to read how to fix it.