Microsoft Office Tutorials and References
In Depth Information
Using Names to Work with Ranges
Type a name in the Name text ﬁ eld (or use the name that Excel proposes, if any). The
selected cell or range address appears in the Refers To text ﬁ eld. Use the Scope drop-down
list to indicate the scope for the name. The scope indicates where the name will be valid,
and it’s either the entire workbook or a particular sheet. If you like, you can add a
comment that describes the named range or cell. Click OK to add the name to your workbook
and close the dialog box.
Using the Create Names from Selection dialog box
You may have a worksheet that contains text that you want to use for names for adjacent
cells or ranges. For example, you may want to use the text in column A to create names for
the corresponding values in column B. Excel makes this task easy.
To create names by using adjacent text, start by selecting the name text and the cells that
you want to name. (These items can be individual cells or ranges of cells.) The names must
be adjacent to the cells that you’re naming. (A multiple selection is allowed.) Then choose
Create from Selection. Excel displays the Create Names from
Selection dialog box, shown in Figure 14.22.
Deﬁ ned Names
The check marks in the Create Names from Selection dialog box are based on Excel’s
analysis of the selected range. For example, if Excel ﬁ nds text in the ﬁ rst row of the selection,
it proposes that you create names based on the top row. If Excel didn’t guess correctly,
you can change the check boxes. Click OK, and Excel creates the names. Using the data in
Figure 14.22, Excel creates six names: January for cell B1, February for cell B2, and so on.
Use the Create Names from Selection dialog box to name cells using labels
that appear in the worksheet.