Excel HYPERLINK function

Function              HYPERLINK

Description        Excel HYPERLINK function creates a link to any file stored on a network server, local disk, an intranet, or the Internet

Syntax  HYPERLINK(link_location, [friendly_name])

Link_location   Mandatory. The location path or link to any file or webpage or any document.

Friendly_name    Optional. The name of the link which may be text or numeric value that is displayed in the cell.

 

Example:

=HYPERLINK(“https://excelabcd.co.in/functions”, “Go to Functions”)

Follows the link at https:// excelabcd.co.in/functions. The cell displays ” Go to Functions ” as its Friendly_name.