Page 346 - Excel 2013 All-in-One For Dummies

328 Range Names in Formulas
Figure 1-13:
Pasting
the range name for the discount_ rate constant into a formula.
Creating names from column and row headings
You can use the Create from Selection command button on the Formulas tab of the Ribbon to assign existing column and row headings in a table of data to the cells in that table. When using this command button, you can have Excel assign the labels used as column headings in the top or bottom row
of the table, the labels used as row headings in the leftmost or rightmost column, or even a combination of these headings.
For example, the sample worksheet in Figure 1-14 illustrates a typical table layout that uses column headings in the top row of the table and row head- ings in the first column of the table. You can assign these labels to the cells in the table by using the Create from Selection command button as follows:
1. Select the cells in the table, including those with the column and row labels that you want to use as range names.
For the example shown in Figure 1-14, you select the range B2:E7.
2. Click the Create from Selection command button on the Formulas tab or press Alt+MC.
This action opens the Create Names from Selection dialog box that con- tains four check boxes: Top Row, Left Column, Bottom Row, and Right Column. The program selects the check box or boxes in this dialog box based on the arrangement of the labels in your table. In the example shown in Figure 1-14, Excel selects both the Top Row and Left Column