Question: how to name a range in excel?
Answer: Select the labels and the cells that are to be named. ... 
On the Ribbon, click the Formulas tab, then click Create from Selection.
In the Create Names From Selection window, add a check mark for the location of the labels, then click OK. ... 
Click on a cell to see its name.