Syntax. HYPERLINK(link_location,friendly_name)
Definition. This function creates a link to a document stored on your hard drive, on a network server, or on a server on an intranet or the Internet.
Arguments
link_location (required). Expects an expression that can be evaluated to a string and specifies the name and path of the document to be opened.
friendly_name (optional). The text displayed in the cell. You can use any expression that can be evaluated to text, a number, a logical value, or an error value. If this argument is omitted, the evaluation of the link_location argument is displayed.
Background. You can use this function to calculate dynamic links, instead of creating static links by pressing Ctrl+K.
If the first argument can be evaluated as a valid address and the correct application (such as Microsoft Word or Windows Internet Explorer) is installed, the file opens in the application when you click the cell containing the function.
To edit the cell, click the cell and hold down the mouse button until the pointer changes into a cross.
If you don’t enter a valid address in the first argument, you will get an error message.
Examples. The following examples show how this function is used.
Linking to Microsoft Office Online. The following entry opens Internet Explorer and displays the Office website from Microsoft:
=HYPERLINK("http://office.microsoft.com/en-us/default.aspx ","Internet test")The text Internet test is displayed in the cell as a link.
Accessing Word documents. The entry
=HYPERLINK("document#highlight","Word test")opens the Word document (assuming that the document resides in the same folder as the worksheet), and the text highlight is selected. The text Word test is displayed in the cell as a link.
You can achieve almost the same effect if you select text in Word, copy this text into the Clipboard, and then insert the text in a worksheet by clicking Insert/Insert As Hyperlink (in Excel 2003) or Insert/Hyperlinks/Hyperlink (in Excel 2007 or Excel 2010). The content of the cell is displayed. The functionality of the hyperlink depends on the cell and can be changed by clicking the right mouse button.