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
link_location: Where the link goes, in quotes: "https://example.com", or "#Sheet2!A1" for a cell.friendly_name(optional): The text the cell shows. Left out, the cell shows the address itself.
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
A link with its own text
A B C 1 Site 2 https://example.com Open the site In C2:
=HYPERLINK(A2, "Open the site")→ Open the siteAn email link for each person
A B C D 1 Name Email 2 Ana ana@example.com Email Ana In D2:
=HYPERLINK("mailto:" & B2, "Email " & A2)→ Email AnaA link to a cell on another sheet
A 1 Contents 2 Go to the summary In A2:
=HYPERLINK("#Summary!A1", "Go to the summary")→ Go to the summaryThe # means a place in this workbook.
Common mistakes
- No https://. A web address needs https:// in front, or Excel looks for a file with that name.
- A link inside the workbook without #. To jump to a cell, start the address with #: "#Sheet2!A1".
- Selecting the cell. Clicking a link follows it. To select the cell instead, click and hold for a moment, or move to it with the arrow keys.
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.
- Czech: HYPERTEXTOVÝ.ODKAZ
- Danish: HYPERLINK
- Dutch: HYPERLINK
- Finnish: HYPERLINKKI
- French: LIEN_HYPERTEXTE
- German: HYPERLINK
- Hungarian: HIPERHIVATKOZÁS
- Italian: COLLEG.IPERTESTUALE
- Norwegian: HYPERKOBLING
- Polish: HIPERŁĄCZE
- Portuguese (Brazil): HIPERLINK
- Portuguese (Portugal): HIPERLIGAÇÃO
- Russian: ГИПЕРССЫЛКА
- Spanish: HIPERVINCULO
- Swedish: HYPERLÄNK
- Turkish: KÖPRÜ
Try HYPERLINK in the playground
Related functions
- ENCODEURL: Text made safe to put in a web address: spaces become %20, and so on.
- TEXTJOIN: Joins text with a separator between each item.
- CONCAT: Joins text from several values or ranges.
- INDIRECT: Turns text such as "B2" into a real reference to that cell or range.
- CELL: Tells you something about a cell: its address, row, column, contents, number format or the type of value in it.