Microsoft Excel gives us an easy way to assign descriptive names to cell ranges. These * named ranges* can be used in formulas and functions in place of a cell reference.

Using a named range offers several benefits. First of all, a descriptive name is more meaningful than a cell reference. For example, a formula that reads =PointsEarned/TotalPoints is easier to understand than =B5/H12.

Named ranges can also reduce typing errors. Microsoft Excel will offer suggestions as you enter a formula. If you have named ranges in your workbook, Excel will show those names as suggestions.

Finally, named ranges can be used as absolute references. If a named range is used in a formula or a function, that reference will not adjust relative to the row.