Entering Named Ranges Into
Formulas
When you write a formula, sometimes you want to
use a Named Range as one of the arguments for the formula, but you cannot
remember the name. In these times simply push F3 when you reach
the argument that you want the Named Range in and Excel will display the
Paste Name dialog. Click the name you want then
OK.