Excel > Excel 2007 Intermediate > Named Ranges

Using Range Names in Formulas

A range name can be referenced within a formula.

When writing the formula, just enter the range name instead of the cell reference. When you do so, the range name should change colour indicating that Excel recognises that name.

Entering a range name in a formula

If you are unsure of the named range's spelling, you can paste the range name into the formula

In the formula bar:

  1. Click the Formulas tab on the Ribbon
  2. Click Use in Formula from the Defined Names group
  3. Select the necessary named range from the list
  4. Use in Formula list

Follow us on

Facebook  Twitter  You Tube