Name range in Excel is a way to define a range to be used in Formula.
For example you may be using a formula =Sum(C1:C10). You can replace range C1:C10 with a name (example, EmployeeSalary).
Select cell range, Go to Formula -> Define Name and provide a name and enter
To use it in Formula, Go to Name Manager and select the name.
