Range names are meaningful character strings that you can assign to individual cells or cell ranges. You can use a range name practically any where you can use a cell or range reference. The advantage of using names comes from the fact that a name, like Employees, is more meaningful and lees abstract than a reference like C2:C55. Also, named ranges are by default absolute, so if you copy or AutoFill a formula using named ranges, it will maintain its original cell references.

 

Names will make formulas much more readable, and in addition, they will make it easier to find and reference individual cells. When you are first designing your worksheet, you can actually enter formulas using names instead of traditional cell references, and then define the names for the corresponding ranges of data as required. Basically, using Names in your worksheet improves clarity, improves organization and aids in the overall design.