The HYPERLINK() is a Lookup and Reference function, which takes the argument "link_location, friendly_name" and creates a shortcut to a file/document saved in local system or internet address.


=HYPERLINK (link_location,friendly_name)
In the above syntax, the argument "link_location" refers to the path and name of the document
"Friendly_name" refers to either the jump text or numerical value that is exhibited in blue color in a particular cell.

Video Tutorial:

Let us see how the HYPERLINK function launches a document with the help of the below video.

Learn MS Excel

Ask Questions

Ask Question