Microsoft Office Tutorials and References
In Depth Information
Figure 3-2: The New Name dialog box.
In the New Name dialog box, you name the name, define its scope and what it refers to, and (optionally) add
any comments about the name to help yourself and others understand its purpose. The Refers To field displays
the range address that was selected when you invoked the dialog box. You can change the address displayed by
typing or by selecting cells in the worksheet.
Clicking the Edit button in the Name Manager displays the Edit Name dialog box, which looks strikingly simil-
ar to the New Name dialog box. You can change any property of your name except the scope. If you change the
Name field, all the formulas in your workbook that use that name will be updated.
To change the scope of a name, you must delete the name and re-create it. If you're
careful to use the same name, your formulas that use that name will still work.
The Edit Name dialog box isn't the only way to edit a name. If the only property that you want to change is the
Refers To property, you can do it right in the Name Manager dialog box. At the bottom of the dialog box is the
field labeled Refers To. Simply select the name that you'd like to edit in the main window and change the refer-
ence in the Refers To field.
If you edit the contents of the Refers To field manually, the status bar displays Point, in-
dicating that you're in point mode. If you try to use keys such as the arrows, Home, or
End, you'll find that you're navigating around the worksheet rather than editing the Re-
fers To text. This is a constant source of frustration to many Excel users. But there's a
simple solution. To switch from point mode to edit mode, press F2 and note that the
status bar changes to show Edit.