Excel Function : HYPERLINK

Download now!

Excel Function : HYPERLINK


Lookup and reference


Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet

Microsoft Excel Reference Page


Syntax and Description of the HYPERLINK Excel Function

The syntax of the HYPERLINK function in Microsoft Excel is as follows: =HYPERLINK(link_location, [friendly_name]) Where link_location is the URL or file path of the target link, and friendly_name is an optional display name for the link.

About HYPERLINK Excel Function

The HYPERLINK function in Excel creates a hyperlink to a file, a web page, or another location in a workbook. The syntax for the HYPERLINK function is: HYPERLINK(link_location, [friendly_name]) link_location is the URL or file path for the link. friendly_name is the optional text that you want to display in the cell. If you don't include friendly_name, the cell displays the link_location.