Microsoft Office Tutorials and References
In Depth Information
Creating names from text in cells
You may have a worksheet containing text that you want to use for names of adjacent cells or ranges. Figure 3-4
shows an example of such a worksheet. In this case, you might want to use the text in column A to create names
for the corresponding values in columns B through M. Excel makes this very easy to do.
Figure 3-4: Excel makes it easy to create names by using text in adjacent cells.
To create names by using adjacent text, start by selecting the name text and the cells that you want to name.
(These can consist of 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 Formulas ⇒ Defined Names ⇒ Create from Selection (or
Ctrl+Shift+F3). Excel displays the Create Names from Selection dialog box, as shown in Figure 3-5.
The check marks in this dialog box are based on Excel's analysis of the selected range. For example, if Excel
finds text in the first row of the selection, it proposes that you create names based on the top row. If it finds text
in the first column, it proposed to create names based on those cells. If Excel doesn't guess correctly, you can
change the check boxes. Click OK, and Excel creates the names.
Note that when Excel creates names using text in cells, it does not include those text cells in the named range.