Skip to content

Excel function · Lookup & reference

Excel HYPERLINK function

HYPERLINK puts a link in a cell that opens a web page, a file or an email window when clicked. Because the address can be built with a formula, it is handy for things like tracking links made from order numbers.

In Turkish Excel: KÖPRÜ

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

English Excel=HYPERLINK(link_location, [friendly_name])
Turkish Excel=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

ArgumentRequiredDescription
link_locationRequiredThe address to open, as text: "https://www.ecb.europa.eu", "mailto:sales@example.com", "#B40", or an expression that builds it.
friendly_nameOptionalThe 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.

C2fx=HYPERLINK("https://example.com/track/"&A2,"Track: "&A2)
Build a tracking link from an order number: example table
ABC
1Order NoCustomerTracking
2SO-10452North MarketTrack: SO-10452
3SO-10453Atlas LtdTrack: SO-10453
4SO-10458Blue ElectricTrack: SO-10458
5SO-10461West BuildTrack: 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.

C2fx=HYPERLINK("mailto:"&B2,"Send email")
Turn an email address into a clickable link: example table
ABC
1DealerEmailLink
2North Marketnorth@example.comSend email
3Atlas Ltdatlas@example.comSend email
4Blue Electricblue@example.comSend 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

Type this in Nexell

Add a tracking link column to the order list, starting with https://example.com/track/ followed by each order number

Convert to table

Bring 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.

Related functions

All lookup & reference functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free