United States
(
change
)
|
All Microsoft Sites
Sign in to My Office Online (
What's this?
) |
Sign in
Home
Products
Help and How-to
Downloads
Clip Art
Templates
Microsoft Office Live
Microsoft Office Excel
Search
Search
Check for free updates
Office downloads
Microsoft Office Excel
»
Excel Home
Product Information
»
Overview
»
Top 10 Reasons to Try
»
See It in Action
»
Pricing Information
»
Free 60-day Trial
»
Buy Now
Help and How-to
»
Excel 2007 Help
»
Excel 2003 Help
»
Excel 2002 Help
»
Excel 2000 Help
Choose your version
»
Excel Web Access
Training
»
Excel 2007 Training
»
Excel 2003 Training
»
Excel 2007 Demos
»
Excel 2003 Demos
»
Excel 2007 Webcasts
»
Excel 2003 Webcasts
Templates
»
Excel Templates
»
Submit a Template
Related Products and Technologies
»
Duet for Microsoft Office and SAP
»
SQL Server Data Mining Add-ins for the 2007 Office release
Support and Feedback
»
Product Support
»
Send Us Your Comments
Technical Resources
»
Developer Center
»
Office Resource Kit
Additional Resources
»
Office Marketplace
»
Discussion Groups
»
Excel Solutions
»
Excel MVPs
Home
>
Products
>
Excel
>
Excel 2003 Help and How-to
>
Working with Data
>
Formulas
>
Creating Formulas
>
Names and Labels
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later.
Learn more about supported browsers.
Email this link
Printer-Friendly Version
Share
Create a name to represent a formula or a constant
Applies to:
Microsoft Office Excel 2003
Show All
Hide All
On the
Insert
menu, point to
Name
, and then click
Define
.
In the
Names in workbook
box, enter the name for the formula.
In the
Refers to
box, type
=
(equal sign), followed by the formula or the
constant
(constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.)
value.
See Also
Audio course: Get to know Excel: Enter formulas
Buy Microsoft Office 2007
Figure out dates by using formulas
Free trial of the 2007 Microsoft Office system
Get to know Excel 2007: Enter formulas
Get to know Excel: Enter formulas
Make time count by using formulas
advertisement
Printer-Friendly Version
16