Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

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:[email protected]").

* 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.

Print this tip.

- Subscribe!

Search the Site: