How to name a range
There are different ways to name a cell or a range, such as:
Select the range A1:A7, go to the Name Box and type your desired name.
To name a range through the Name Manager, execute the following steps:
1- Select the range A1
2- In the Formulas tab, go to the Defined Names section and click Name Manager.
Result. Name Manager box will appear.
Shortcut key alert: You can also open the Name Manager box by pressing Ctrl + F3.
3- On the Name Manager box window, click New or press N button.
4- Enter the desired Name e.g. ‘Price’ and press OK.
5- Result. Excel will named the range as ‘Price’.