MS-Excel / Excel 2003

Using range names in new formulas

If you named a cell range or constant that you need to refer to in a new formula, you can use its name when building a formula. To enter the name, you can either type it (risky business if you have any trouble remembering the exact name), or you select its name from the Paste Name dialog box.

Selecting the name from the Paste Name dialog box is much easier - especially when dealing with constants that don't show up anywhere on the worksheet - unless you've pasted a list of range names somewhere within it (Insert → Name → Paste, Paste List).

[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