Naming a Range
We can add a descriptive range name to a cell or a range of cells. A name makes formulas easier to read and understand.
On the menu choose Insert, then Name and then Define. In the Define Name window, Excel will try to propose a name based on the contents of the cell to the left of the active cell.
In place of the cell reference in the Name box of the formula bar, the name of the cell is displayed.