MS-Excel / Excel 2003

Using Your Range Names in Formulas

The great thing about using range names in your formulas is that they automatically document their function. This is especially helpful to coworkers who have to use your spreadsheets but who had no part in their design. When using names in your formulas, you can assign the names as you construct new formulas in the worksheet, or you can add them after the fact to existing formulas.

Following these sections:
Using range names in new formulas and Assigning range names to existing formulas

[Previous] [Contents] [Next]

In this tutorial:

  1. Excel 2003 Using Range Names
  2. Name That Range
  3. Creating names from row and column headings
  4. Assigning range names that span different sheets
  5. Assigning Range Names to Constants
  6. Using Your Range Names in Formulas
  7. Using range names in new formulas
  8. Assigning range names to existing formulas