Pasting Names into Formulas

PASTING NAMES INTO FORMULAS

After you define one or more names in your worksheet, you can insert those names in formulas using the Paste Name dialog box. Use the Paste Name dialog box to insert names in your formulas. For example, to paste the name Qtr_1 into a formula:

Type an equal sign and then type the operators, functions, or constants of your formula.
Place the insertion point in the formula where you want to insert the name, and then choose Insert, Name, Paste (or press F3).
Select Product_1, and click OK to insert the name in the formula.
Type any other operands and operators to complete the formula, and then press Enter.

Using the previous example, Paste Names may not seem like a very compelling feature, unless your defined names are too long or cryptic to reliably type into formulas.