HYPERLINK function

Category: Lookup and reference functions

What does this function do?

Creates a shortcut or jump to a document saved on the hard drive, a network server or Internet.

Syntax:

HYPERLINK(link_location, [friendly_name])

• Link_location (required): The path and file name to the document to be opened. 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 that is stored on a hard disk drive. The path can also 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.

• Friendly_name (optional): 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.

Examples:

=HYPERLINK("http://thewizardofexcel.blogspot.com/", "The Wizard of Excel")

=HYPERLINK(“D:\Finance\Example.xlsx”; H10)