Skip to content
Google Sheets

HYPERLINK function in Google Sheets

Creates a hyperlink inside a cell.

=HYPERLINK(url, [link_label])

HYPERLINK syntax and parameters

Two arguments, one required.

  • urlstringRequired

    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_labelstringOptional

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

HYPERLINK examples

Formulas you'll actually reuse.

  1. A click-through link built from the order ID in column A:

    =HYPERLINK("https://example.com/orders/" & A2, "Open order " & A2)

  2. A mailto link with the invoice number already in the subject line:

    =HYPERLINK("mailto:" & B2 & "?subject=Invoice%20" & A2, "Email customer")

HYPERLINK in Excel

Same name — your formula ports as-is.

Try HYPERLINK in the playground

Edit the example — nothing to install.

Preloaded with the HYPERLINK formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.