Creates a hyperlink inside a cell.
Sample Usage
HYPERLINK("http://google.com/","Google")
Syntax
HYPERLINK(url, [link_label])
-
url
- The full URL of the link location enclosed in quotation marks, or a reference to a cell containing such a URL.-
Only certain link types are allowed.
http://
,https://
,mailto:
,aim:
,ftp://
,gopher://
,telnet://
, andnews://
are permitted; others are explicitly forbidden. If another protocol is specified,link_label
will be displayed in the cell, but will not be hyperlinked. -
If no protocol is specified,
http://
is assumed, and is prepended tourl
.
-
-
link_label
- [ OPTIONAL -url
by default ] - The text to display in the cell as the link, enclosed in quotation marks, or a reference to a cell containing such a label.-
If
link_label
is a reference to an empty cell,url
will be displayed as a link if valid, or as plain text otherwise. -
If
link_label
is the empty string literal (""), the cell will appear empty, but the link is still accessible by clicking or moving to the cell.
-
Notes
-
Failure to enclose
url
(orlink_label
, if provided) in quotation marks will cause an error. -
Google Sheets automatically converts most valid URL types when typed into a cell without the need to use this function.
Examples
Creates a hyperlink inside the cell for specified cell_text
.