Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.

The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to interpret the parts of complex formulas. Microsoft ...