Learn Excel - Simplify Life with Excel Concepts

Excel HYPERLINK Function

HYPERLINK Function

How to use the HYPERLINK Function (WS)

This Excel tutorial explains how to use the Excel HYPERLINK function with syntax and examples.

SUMMARY:

The HYPERLINK function creates 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 HYPERLINK function can build links to workbook locations, pages on the internet, or to files on network servers.

For example,

  • When you click a cell that contains a HYPERLINK function, Excel jumps to the location listed, or opens the document you specified.
  • The Excel HYPERLINK function returns a hyperlink from a given destination and "friendly name".

PURPOSE:

To creates a clickable link or shortcut that jumps to another location

RETURN VALUE:

The HYPERLINK function generate a clickable hyperlink that jumps to another location when we click on it.

SYNTAX:

=HYPERLINK(link_location, [friendly_name])

ARGUMENTS:

The HYPERLINK function syntax has the following arguments:

  • link_location: Required. The path to the file name or the URL to the Internet address. Link_location can refer to a place in a document.
  • friendly_name: Optional. It is the value that appears in the cell.
    • If friendly_name is omitted, the cell displays the link_location as the jump text.
    • If friendly_name returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.
    • friendly_name can be a value, a text string, a name, or a cell that contains the jump text or value.

REMARKS:

  • HYPERLINK function can be use to create links to workbook locations, pages on the internet, or to files on network servers.
  • Link_location should be supplied as a text string in quotation marks or a cell reference that contains the link path as text.
  • If friendly_name is not supplied, the HYPERLINK will display link_location as the friendly_name.
  • In the Excel desktop application, to select a cell that contains a hyperlink without jumping to the hyperlink destination, click the cell and hold the mouse button until the pointer becomes a cross Excel selection cursor + , then release the mouse button.
  • In Excel for the web, select a cell by clicking it when the pointer is an arrow; jump to the hyperlink destination by clicking when the pointer is a pointing hand.

Useful Links: Link 1Link 2Link 3