Chapter 4: Working with Cells and Ranges
93
FIGURE 4.15
Use the Name Manager to work with range names.The Name Manager appears when you choose Formulas ➪ Defined Names ➪ Name Manager
(or press Ctrl+F3). The Name Manager has the following features:l Displays information about each name in the workbook. You can resize the Name
Manager dialog box and widen the columns to show more information. You can also click
a column heading to sort the information by the column.l (^) Allows you to filter the displayed names. Clicking the Filter button lets you show only
those names that meet a certain criteria. For example, you can view only the worksheet
level names.
l Provides quick access to the New Name dialog box. Click the New button to create a
new name without closing the Name Manager.
l Lets you edit names. To edit a name, select it in the list and then click the Edit button.
You can change the name itself, modify the Refers To range, or edit the comment.
l Lets you quickly delete unneeded names. To delete a name, select it in the list and
click Delete.
Caution
Be extra careful when deleting names. If the name is used in a formula, deleting the name causes the formula
to become invalid. (It displays #NAME?.) However, deleting a name can be undone, so if you find that formulas
return #NAME? after you delete a name, choose Undo from the Quick Access toolbar (or press Ctrl+Z) to get
the name back. n
If you delete the rows or columns that contain named cells or ranges, the names contain an invalid
reference. For example, if cell A1 on Sheet1 is named Interest and you delete row 1 or column A,
the name Interest then refers to =Sheet1!#REF! (that is, to an erroneous reference). If you use
Interest in a formula, the formula displays #REF.