Managing Range Names

As you assign range names in your workbook, their names appear in the Name Manager dialog box. You open this dialog box by clicking the Name Manager command button on the Formulas tab of the Ribbon or by pressing Alt+MN.

The Name Manager enables you to do any of the following:

• Create new range names for the worksheet or workbook in the New Name dialog box opened by clicking the New button.
• Edit existing range names in the Edit Name dialog box by clicking the name in the list box and then clicking the Edit button - you can change both the name and cell selection when editing a range name.
• Delete existing range names by clicking the name and then clicking the Delete button followed by the OK button in the alert dialog box asking you to confirm its deletion.
• Filter the range names in the list box of the Name Manager by clicking the Filter button and then clicking a filter option (Names Scoped to Worksheet, Names Scoped to Workbook, Names with Errors, Names without Errors, Defined Names, or Table Names) on its dropdown menu.

Be careful that you don't delete a range name that is already used in formulas in the worksheet. If you do, Excel will return the #NAME! error value to any formula that refers to the name you deleted!

The Name Manager will not display hidden names (where the Visible property is set to false) or names defined in Visual Basic for Applications (VBA).