Skip to content
Excel

HYPERLINK function in Excel

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet

=HYPERLINK(link_location, [friendly_name])

HYPERLINK syntax and parameters

Two arguments, one required.

  • link_locationstringRequired
  • friendly_nameanyOptional

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 Google Sheets

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 Excel gets this done.