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

check boxes because the table contains both column headings in the top row and row headings in the left column.
3. After selecting (or deselecting) the appropriate Create Names In check boxes, click the OK button to assign the range names to your table.
Note that when you select both the Top Row and Left Column check boxes in the Create Names from Selection dialog box, Excel assigns the label in the cell in the upper-left corner of the table to the entire range of values in the table (one row down and one column to the right).
Figure 1-14:
Creating range names from the row
and column headings ina spreadsheet table.
Range Names in Formulas 329
In the example illustrated in Figure 1-14, Excel assigns the name Description (the heading for column B) to the cell range C3:E7. Similarly, the program assigns the column headings to the appropriate data in the table in the rows below, and assigns the row headings to the data in the appropriate columns to the right so that the name Retail_Price is assigned to the cell range C3:C7 and the name China_Hutch is assigned to the cell range C7:E7.
Managing range names
As you assign range names in your workbook, their names appear in the Name Manager dialog box. (See Figure 1-15.) You open this dialog box by clicking the Name Manager command button on the Formulas tab of the Ribbon or by pressing Alt+MN.
Book III Chapter 1
Building Basic Formulas