The HYPERLINK function creates a hyperlink in a cell.
Hyperlinks allow users to quickly navigate to the information they need.
Syntax
HYPERLINK(url, [link_label])
Argument |
Description |
Permitted values |
|---|---|---|
url |
URL that will open when clicked |
Address of the link enclosed in quotation marks, or a reference to the cell that contains the address |
[link_label] |
(optional) Text of the link displayed in the cell, or a reference to the cell containing such text. By default, the link address will be displayed |
Text string or reference to a cell containing text |
Examples of use
Hyperlink to the website
=HYPERLINK(“https://www.myoffice.ru”, “Go to the MyOffice website”)
As a result, the text “Go to the MyOffice website” will be displayed in the cell, and clicking it will open the specified website.
Hyperlink to an external file
=HYPERLINK("C:\Reports\First_Quarter.xlsx", "Open report")
Result: clicking the link opens the specified document.
Notes
If you move or delete an external file, the links to it will become inactive.