Microsoft Excel 2003 Functions and Formulas
Create Internet Hyperlink
Summary: Create a web or e-mail hyperlink in your Microsoft Excel 2003 spreadsheet.
To programmatically create a hyperlink to a website, e-mail address, or other Internet address from within a Microsoft Excel 2003 spreadsheet, use the =HYPERLINK function.
=hyperlink("ADDRESS","DESCRIPTION")
* ADDRESS is the fully-qualified Internet address to visit when the hyperlink is clicked (such as "http://websitename.com" or "mailto:phony.email.address@donotsendhere.com").
* DESCRIPTION is the underlined text shown in the Excel 2003 spreadsheet.
For example, the following formula will create a hyperlink to "http://www.malektips.com" with the description "Free computer tips!":
=hyperlink("http://www.malektips.com","Free computer tips!")
When clicked Microsoft Excel 2003 should use your default web browser, e-mail software, or other default Internet software depending on the type of hyperlink.
Add:
Del.icio.us |
Digg |
Furl |
My Yahoo!
Last Modified on: July 13, 2008, at 12:04 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
