What it does
The first argument is where the link goes: a web address (https://…), an email (mailto:…) or a file path. The second is the text shown in the cell; without it, the address itself is shown. The cell displays that text and opens the address when clicked.
Because the address is text, it can be built from pieces with &: a fixed beginning plus the order number from a cell gives every row its own link. The text shown can be a formula too, such as the order number itself.
To jump to a cell on the same sheet, start the address with #: =HYPERLINK("#B40","Go to totals"). For long addresses made of several parts, CONCAT or TEXTJOIN can help.
Syntax
=HYPERLINK(link_location, [friendly_name])=KÖPRÜ(bağ_konumu; [kolay_ad])Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
link_location | Required | The address to open, as text: "https://www.ecb.europa.eu", "mailto:sales@example.com", "#B40", or an expression that builds it. |
friendly_name | Optional | The text or number shown in the cell. If omitted, link_location is shown. |
Examples
1Build a tracking link from an order number
The fixed start of the address is joined with the order number in column A using &, and the displayed text is built from the number too. The example uses example.com, which is reserved for documentation; put your carrier's address in its place.
=HYPERLINK("https://example.com/track/"&A2,"Track: "&A2)| A | B | C | |
|---|---|---|---|
| 1 | Order No | Customer | Tracking |
| 2 | SO-10452 | North Market | Track: SO-10452 |
| 3 | SO-10453 | Atlas Ltd | Track: SO-10453 |
| 4 | SO-10458 | Blue Electric | Track: SO-10458 |
| 5 | SO-10461 | West Build | Track: SO-10461 |
- C2 (filled down to C5)
=HYPERLINK("https://example.com/track/"&A2,"Track: "&A2)
C2 shows Track: SO-10452; clicking it opens https://example.com/track/SO-10452. Every row links to the address of its own order number.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Turn an email address into a clickable link
An address starting with mailto: opens a new message in the email program with the recipient filled in. The displayed text is the same on every row.
=HYPERLINK("mailto:"&B2,"Send email")| A | B | C | |
|---|---|---|---|
| 1 | Dealer | Link | |
| 2 | North Market | north@example.com | Send email |
| 3 | Atlas Ltd | atlas@example.com | Send email |
| 4 | Blue Electric | blue@example.com | Send email |
- C2 (filled down to C4)
=HYPERLINK("mailto:"&B2,"Send email")
The cells show only Send email; clicking C3 opens a new message addressed to atlas@example.com.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Link does not open
Cause: The address is incomplete or wrong; for example
https://is missing or a joined cell has an extra space.Fix: Build the address text in a separate cell first and check it; remove spaces with TRIM.
- #VALUE!
Cause: The address is longer than 255 characters, or the formula that produces friendly_name returns an error.
Fix: Shorten the address; fix the formula that builds the displayed text.
Good to know
- To edit a linked cell, do not click it; move to it with the arrow keys and press F2. Clicking opens the link.
- If the text shown is a number, the cell behaves like a number and can be added up and sorted.
In Nexell
Get Nexell to do it from a sentence
Add a tracking link column to the order list, starting with https://example.com/track/ followed by each order number
Convert to tableBring your order list into the tool and type this. Nexell writes the tracking address for each order number into a new column and shows it in a preview first; once you approve, you download it as .xlsx.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I link to another sheet in the workbook with HYPERLINK?
Start the address with #, then the sheet name and the cell: =HYPERLINK("#'October Sales'!A1","Go to October"). If the sheet name has no spaces, you can drop the single quotes.