How to Use HYPERLINK Function

The HYPERLINK function creates a shortcut to open a document stored on a network server, an intranet or the Internet.


= HYPERLINK(link_location, [friendly_name])


  • Link_location is required, the link to the file (e.g., internet, network server).
  • Friendly_name is optional. The name you gave to the link to the location. When friendly_name is omitted, the function uses link as the name.

=HYPERLINK("","your best excel source"). B2 displays the name "you best excel source".

=HYPERLINK(""), the friendly name is omitted, so the result returns the link itself as the friendly name.

Download: HYPERLINK Function

Leave a Reply