Microsoft Office Tutorials and References
In Depth Information
If the text contained in a cell would result in an invalid name, Excel modii es the name to make it valid. For example,
if a cell contains the text Net Income (which is invalid for a name because it contains a space), Excel converts the
space to an underscore character. If Excel encounters a value or a numeric formula where text should be, however, it
doesn’t convert it to a valid name. It simply doesn’t create a name — and does not inform you of that fact.
If the upper-left cell of the selection contains text and you choose the Top Row and Left Column options, Excel uses
that text for the name of the entire range, excluding the top row and left column. So, after Excel creates the names,
take a minute to make sure that they refer to the correct ranges. If Excel creates a name that is incorrect, you can
delete or modify it by using the Name Manager (described next).
A workbook can have any number of named cells and ranges. If you have many names, you
should know about the Name Manager, shown in Figure 14.23.
Use the Name Manager to work with range names.
The Name Manager appears when you choose Formulas
Deﬁ ned Names
Name Manager (or
press Ctrl+F3). The Name Manager has the following features:
Displays information about each name in the workbook: You can resize the
Name Manager dialog box, widen the columns to show more information, and even
rearrange the order of the columns. You can also click a column heading to sort the
information by the column.