Excel Function : HYPERLINK

Download now!

Excel Function : HYPERLINK

Category

Lookup and reference

Description

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

Microsoft Excel Reference Page

https://support.office.com/en-us/article/HYPERLINK-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f

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.