Excel 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.
