Microsoft Office Tutorials and References
In Depth Information
U SE A C ONSTANT OR R ANGE
N AME IN A F ORMULA
Note: Use this technique if
you forget the name of a
constant or range.
Begin typing your
Click the Formulas tab.
Click Use in Formula.
A menu appears.
Click the constant or
range name you want
If necessary, continue
typing your formula and
press Enter when you
l Excel feeds the selected constant or range
name into the formula, which then
displays a result based on it.
Did You Know?
To create several named constants at the same time,
create two adjacent columns, one listing names and
the other listing the values — for example, state names
and state sales tax rates. Select both columns. Click
the Formulas tab and then click Create from Selection.
The Create Names from Selection dialog box appears.
Click a check box to indicate which column or row to
use for the name. Click OK. Click Name Manager to
see the constants listed in the Name Manager dialog
box. Use the same procedure to create named ranges.
Did You Know?
Naming a formula enables you to reuse it by merely
typing its name. To create a named formula, click in
the cell that contains the formula, click Formulas, and
then click Define Name. The New Name dialog box
appears. Type a name for the formula in the Names
field, define its scope, and then click OK.
Chapter 2: Work with Formulas and Functions