This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Create Internet Hyperlink

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.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Create Internet Hyperlink.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.