Microsoft Office Tutorials and References
In Depth Information
D ISPLAY A C ONSTANT
Click in a cell.
Type an equal sign
followed by the first
letter or letters of the
A menu appears.
Note: If you do not know
the constant’s name,
click the Formulas tab
and then Use in Formula.
When the menu appears,
click the name and then
Double-click the name of
l The constant’s value appears in the cell.
Note: To use named constants and ranges
in formulas, see Task #13.
Did You Know?
You can use Excel’s name manager to rename, edit, or delete named ranges and constant values.
On the Formulas tab, click Name Manager. The Name Manager dialog box appears. Double-click the
name you want to edit. The Edit Name dialog box appears. Make the changes you want and then
click OK. To delete a constant, click the name in the Name Manager dialog box and then click
Delete. If you want to create a new constant, click New in the Name Manager dialog box. The New
Name dialog box appears; you can make your entries. In addition to formulas, you can also enter
text as a constant value. Simply type the text into the Refers To field.
Chapter 2: Work with Formulas and Functions