HYPERLINK

  • Updated

Creates a hyperlink inside a cell.

 

Sample Usage

HYPERLINK("http://www.spreadsheet.com", "Web address")
HYPERLINK(C5)

Syntax

HYPERLINK(url, [label])

  • url - The full URL or a reference to cell containing the URL. 
  • label - [OPTIONAL] The text to display in the cell as the link or a reference to a cell containing the label. 

 

Examples

HYPERLINK("http://www.spreadsheet.com", "Web address") creates a hyperlink with the label: "Web address". 
HYPERLINK(C5) creates a hyperlink to the URL contained in the cell C5

 

Notes

  • Only certain types of url protocols are allowed.
    http://https://mailto:aim:ftp://gopher://telnet://, and news:// are permitted; others are explicitly forbidden. If a non-permitted protocol is specified,  label will be displayed in the cell, but will not be hyperlinked.
  • If no protocol is specified, http:// is assumed.
  • If label is a reference to an empty cell, url will be displayed as a link if valid, or as plain text otherwise.
  • If url is an empty string literal (""), the cell will appear empty, but the link is still accessible.
  • Enclose url and label in quotation marks.