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]