Syntax
HYPERLINK(link_location,friendly_name)
Link_location is the path and file name to the document to be opened as text. Link_location can refer to a place in a document— such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. The path can be to a file stored on a hard disk drive, or the path can be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet.
· Link_location can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
· If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.
Friendly_name is the jump text or numeric value that is displayed in the cell. Friendly_name is displayed in blue and is underlined. If friendly_name is omitted, the cell displays the link_location as the jump text. · Friendly_name can be a value, a text string, a name, or a cell that contains the jump text or value.
· If friendly_name returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.
Remark To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross (+), then release the mouse button.
Examples
