Microsoft Office Tutorials and References
In Depth Information
Clicking the Delete button in the Name Manager permanently removes the selected name from your workbook.
Excel warns you first because this action cannot be undone.
Unfortunately, Excel does not replace deleted names with the original cell references.
Any formulas that use a name that you delete will display the #NAME? error.
Shortcuts for Creating Cell and Range Names
Excel provides a few additional ways to create names for cells and ranges other than the Name Manager. I dis-
cuss these methods in this section, along with some other relevant information that pertains to names.
The New Name dialog box
You can access the New Name dialog box directly by choosing Formulas ⇒ Defined Names ⇒ Define Name. The
New Name dialog box that's displayed is identical in form and function to the one from the New button on the
Name Manager dialog box.
A single cell or range can have any number of names. I can't think of a good reason to
use more than one name, but Excel does permit it. If a cell or range has multiple names,
the Name box always displays the name that's first alphabetically when you select the
cell or range.
A name can also refer to a noncontiguous range of cells. You can select a noncontiguous range by pressing Ctrl
while you select various cells or ranges with the mouse.
Rules for naming names
Although Excel is quite flexible about the names that you can define, it does have some rules:
• Names can't contain any spaces. You might want to use an underscore or a period character to simulate a
space (such as Annual_Total or Annual.Total ).
• You can use any combination of letters and numbers, but the name must begin with a letter or under-
score. A name can't begin with a number (such as 3rdQuarter ).
• A name cannot look like a cell reference. This excludes names such as Q3 and TAX2012 .