Microsoft Office Tutorials and References
In Depth Information
Creating Cell Names Based on Row Titles
1
Select the
range B4:C6.
Formulas tab
Defi ne Name
button
Click the Formulas
tab on the Ribbon
(Figure 4–10).
Create from
Selection
button
range B4:C6
selected
Figure 4–10
2
Click the Create
from Selection
button on the
Ribbon to display
the Create Names
from Selection
dialog box
(Figure 4–11).
Create Names
from Selection
dialog box
How does Excel
determine
which option to
automatically select
in the the Create
Names from Selection
dialog box?
Excel automatically
selects the Left col-
umn check box in the
‘Create names from
values in the’ area
because the left
column of the cells
selected in Step 1
contains text.
Left column
check box
selected
names in column B
to left will reference
cells in column C
OK button
3
Click the OK button.
Select the range D2:E6 and then click the Create from Selection button on the Ribbon.
Figure 4–11
Click the OK button on the Create Names from Selection dialog box to assign names to the
range E2:E6.
 
Search JabSto ::




Custom Search