Microsoft Office Tutorials and References
In Depth Information
Using Named Constants
SalesTax is a workbook-level name, so you can use it in any worksheet in the workbook.
A named constant can also consist of text. For example, you can define a constant for a
company’s name. You can use the New Name dialog box to create the following formula, named MSFT:
=”Microsoft Corporation”
Then you can use a cell formula, such as this one:
=”Annual Report: “&MSFT
This formula returns the text Annual Report: Microsoft Corporation.
Names that don’t refer to ranges don’t appear in the Name box or in the Go To dialog
box (which appears when you press F5). This situation makes sense because these
constants don’t reside anywhere tangible. They do, however, appear in the Paste
Name dialog box (which appears when you press F3). This does make sense, because
you use these names in formulas.
As you might expect, you can change the value of the constant at any time by using the Name
Manager dialog box (choose Formulas
Name Manager). Just click the Edit
button to display the Edit Name dialog box. Then change the value in the Refers To field. When you
close the dialog box, Excel uses the new value to recalculate the formulas that use this name.
Defined Names
Search JabSto ::

Custom Search