Excel functions / Lookup

HYPERLINK function

Makes a cell a link: to a web page, an email address, or another cell ("#Sheet2!A1"). Select the cell and click its link button, or Ctrl+click it, to follow the link.

Syntax

=HYPERLINK(link_location, [friendly_name])

Arguments

When to use it

HYPERLINK makes a cell a link. The first argument is where it goes: a web address, an email address with mailto: in front, a file, or a cell in the workbook written with a # in front. The second is the text the cell shows.

Because it is a formula, the address can be built from other cells, which is how one formula makes a link for every row of a list. In Excel a click follows the link; here, select the cell and click its link button, or Ctrl+click it (⌘+click on a Mac).

Examples

  1. A link with its own text

    ABC
    1Site
    2https://example.comOpen the site

    In C2: =HYPERLINK(A2, "Open the site") → Open the site

    Try this example

  2. An email link for each person

    ABCD
    1NameEmail
    2Anaana@example.comEmail Ana

    In D2: =HYPERLINK("mailto:" & B2, "Email " & A2) → Email Ana

    Try this example

  3. A link to a cell on another sheet

    A
    1Contents
    2Go to the summary

    In A2: =HYPERLINK("#Summary!A1", "Go to the summary") → Go to the summary

    The # means a place in this workbook.

    Try this example

Common mistakes

HYPERLINK in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try HYPERLINK in the playground

Related functions