HYPERLINK

Creates a hyperlink inside a cell.

Sample usage

HYPERLINK("http://www.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:// and news:// 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 to url.

• 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

• If the url evaluates to an error, the function will return an error.

• Failure to enclose url (or link_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.

Make a copy