The Excel HYPERLINK function creates a clickable link from a formula — to a web page, an email address, a file, or another cell in the workbook — with friendly display text of your choosing. Because it’s a formula, you can build hundreds of links at once from cell values, something Insert > Link can’t do.
Syntax
| Argument | Description | |
|---|---|---|
link_location | Required | Where the link goes: a URL ("https://..."), an email ("mailto:..."), a file path ("C:\Reports\Q1.xlsx" or a UNC path), or a place in this workbook ("#Sheet2!A1"). Text, or a cell containing the text. |
friendly_name | Optional | What the cell displays — text, a number, or another formula’s result. Omitted, the cell shows link_location itself. |
Selecting without following: to select a HYPERLINK cell without triggering it, click and hold until the cursor changes to a cross, or arrow-key into the cell from a neighbour.
Worked examples: web, email, files, and cells
One function, four kinds of destination:
The formula advantage shows when you build links in bulk. Given ticket IDs in column B, one formula filled down creates a clickable tracker:
| A | B | C | |
|---|---|---|---|
| 1 | Ticket | ID | Link |
| 2 | Login bug | 4512 | Open #4512 |
| 3 | Slow report | 4518 | Open #4518 |
| 4 | Typo on invoice | 4523 | Open #4523 |
Try it: build a link
Pick a destination type, tweak the pieces, and watch the HYPERLINK formula and the resulting cell take shape.
Useful patterns: navigation, dynamic targets, escape hatches
A table of contents for a big workbook. List your sheet names in column A, then:
Dynamic targets. Both arguments accept formulas, so a link can follow a lookup:
Search links. Concatenate a query into a search URL:
Removing link styling: HYPERLINK cells keep your cell formatting — unlike Insert > Link, they don’t force blue underlined text. To strip many inserted (non-formula) links instead, select the cells and choose Remove Hyperlinks from the right-click menu.
Errors & common pitfalls
“Cannot open the specified file” on click. The path or URL is wrong, the file moved, or you lack access. The formula itself never errors for a bad destination — HYPERLINK doesn’t validate it. Test links after building them.
Internal links need the #. =HYPERLINK("Sheet2!A1", ...) fails on click; it must be =HYPERLINK("#Sheet2!A1", ...). Sheet names with spaces also need apostrophes: "#'Q1 Sales'!A1".
Pitfall: the link fires on a single click. Users trying to select the cell end up opening the browser. Click-and-hold (or arrow keys) selects without following.
Pitfall: 255-character limit. Very long URLs can exceed what link_location accepts. Shorten the URL or store it in a cell and reference that cell.
Pitfall: security prompts. Links to file shares or non-https locations can trigger Office security notices for your users, and links may be blocked entirely in Protected View.
Practice workbook
Frequently asked questions
How do I link to another sheet in the same workbook?
=HYPERLINK("#Sheet2!A1", "Go to Sheet2"). For sheet names with spaces, add apostrophes: =HYPERLINK("#'Q1 Sales'!A1", "Q1"). You can also link to a named range: "#MyRange".How do I make an email link with a subject line?
=HYPERLINK("mailto:team@dfwexcel.com?subject=Weekly report", "Email us"). Add &body=... for prefilled body text (URL-encode spaces as %20 in stubborn mail clients).How do I select a HYPERLINK cell without opening the link?
Why does my link say it cannot open the specified file?
Can the displayed text come from another formula?
friendly_name takes any expression: =HYPERLINK("https://example.com/" & A2, "Open " & TEXT(B2, "mmm d")). The cell displays the computed text but behaves as a link.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class