Articles with the tag:
Articles with the tag:


The HYPERLINLK function is one of the lookup and reference functions. It is used to create a shortcut that jumps to another location in the current workbook, or opens a document stored on a network server, an intranet, or the Internet.

The HYPERLINLK function syntax is:

HYPERLINLK(link_location [, friendly_name])


link_location is the path and file name to the document to be opened. In the online version, the path can be a URL address only. link_location can also refer to a certain place in the current workbook, for example, to a certain cell or a named range. The value can be specified as a text string enclosed to the quotation marks or a reference to a cell containing the link as a text string.

friendly_name is a text displayed in the cell. It is an optional value. If it is omitted, the link_location value is displayed in the cell.

To apply the HYPERLINLK function,

    or click the Function icon icon situated at the formula bar,
  3. select the Lookup and Reference function group from the list,
  4. click the HYPERLINLK function,
  5. enter the required arguments separating them by comma,
  6. press the Enter button.

The result will be displayed in the selected cell.

To open the link click on it. To select a cell that contains a link without opening the link click and hold the mouse button.


Return to previous page
to see all the features in action