Creating Range Names from Worksheet Labels
You can also create range names using the column and row labels that you have created for your worksheet. The row labels are used to create a range name for each row of cells, and the column labels are used to create a range name for each column of cells . Follow these steps:
You can check the range names (and their range of cells) that were created using the Create Name feature in the Define Name dialog box. Select Insert , point at Name , and then select Define . All the range names that you created appear in the Names in Workbook list.