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).
In this tutorial:
- Using Ranges names for formulas
- Advantages to Naming Cells and Ranges
- Introducing Ranges Names
- Defining Range Name
- Editing Ranges Names
- Managing Range Names
- Creating a Name from a Selection
- Creating a Dynamic Range
- Working with Range and Cell Names
- Using Names in Formulas
- Intersection Operators with Names
- Applying Names to Existing Formula
- Naming Constants and Formulas
- Excel Maintains Cell and Range Names
