Excel > Excel 2003 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.

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

Whilst entering the formula in the formula bar:

1. Click Insert > Name > Paste
2. The Paste Name dialogue box appears

Select the desired range name



3. Click Ok

Creating a range name Managing range names

Guides