Build Clickable Links with HYPERLINK

All versionsHYPERLINK

The HYPERLINK function turns a formula into a clickable link — to a website, a file, an email, or another cell in the workbook — with friendly text. Because it’s a formula, the destination can be built from your data.

Quick formula: to make a clickable link with custom text:

=HYPERLINK("https://dfwexcel.com", "Visit site")

First argument is the destination, second is the text to show. Click the cell and it navigates.

Functions used (tap for the full reference guide):

HYPERLINK

The example

Links built from a base URL and an ID column.

	A	B
1	ID	Link
2	1042	Open #1042
3	1077	Open #1077

The formula

A link whose URL is built from the row’s ID:

=HYPERLINK("https://site.com/order/" & A2, "Open #" & A2) // clickable, per-row link

How it works

Two arguments: where to go, and what to show:

The link_location is the destination — a URL, a file path, an email ("mailto:…"), or an in-workbook cell.
The friendly_name is the clickable text. Omit it and the cell shows the raw destination.
Both can be built from cells, so you can generate a whole column of links from a base URL and an ID.
Clicking the cell navigates — unlike a static pasted hyperlink, this one updates if the data changes.

Jump within the workbook: =HYPERLINK("#Summary!A1", "Go to Summary") links to another sheet/cell — great for a table-of-contents tab. The # means “this workbook.”

Try it: interactive demo

Live demo

Enter an ID; see the link formula and where it points.

Order ID (A2)

Shows: →

Variations

Email link

Open a pre-addressed email:

=HYPERLINK("mailto:" & A2, "Email " & A2)

Jump to another sheet

In-workbook navigation:

=HYPERLINK("#Summary!A1", "Go to Summary")

Open a file or folder

A local path:

=HYPERLINK("C:\\Reports\\" & A2 & ".pdf", "Open PDF")

Pitfalls & errors

The cell isn’t auto-formatted as a link. HYPERLINK is clickable but doesn’t apply blue/underline styling — format the cell yourself if you want the classic look.

Broken destinations fail silently or error on click. A malformed URL or missing file just won’t open. Verify the built string.

In-workbook links need the #. "#Sheet!A1" jumps within the file; without the # Excel treats it as an external path.

Practice workbook

📊

Download the free Build Clickable Links with HYPERLINK practice workbook

Live HYPERLINK examples (web, email, in-workbook, file) with results shown, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I create a clickable link with a formula in Excel?

Use =HYPERLINK(destination, friendly_text), e.g. =HYPERLINK("https://site.com", "Visit"). The destination can be a URL, file path, email, or in-workbook cell, and can be built from other cells.

How do I link to another sheet in the same workbook?

Prefix the reference with #: =HYPERLINK("#Summary!A1", "Go to Summary") jumps to that sheet and cell.

How do I make a mailto link?

Use =HYPERLINK("mailto:" & A2, "Email") where A2 holds the address. Clicking opens a new pre-addressed email.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: HYPERLINK