HYPERLINK Function
Creates a clickable link to a web page, file or place in the workbook.
Category
Lookup & Reference
Available in
All versions, Microsoft 365
Returns
A clickable link
Overview
HYPERLINK turns a cell into a link. Because it's a formula, the destination and the label can be built from other cells.
To link within the same workbook, start the location with #, e.g. "#Summary!A1".
Syntax
=HYPERLINK(link_location, [friendly_name])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| link_location | Yes | The URL, file path or in-workbook location (starting with #) to open. |
| friendly_name | Optional | The text to display. Defaults to the link itself. |
Examples
Example 1 — A labelled web link
Show a friendly label instead of the full URL.
=HYPERLINK("https://id-preview--60d665f6-f4f6-5ef8-8f2a-0c7ab877afe3.lovable.app", "Visit My Excel Academy") Explain
Example 2 — Jump to a sheet named in a cell
A1 contains a sheet name. Build a link that jumps there.
B1fx=HYPERLINK("#'"&A1&"'!A1", "Go to "&A1)
| A | B | |
|---|---|---|
| 1 | March | Go to March |
=HYPERLINK("#'"&A1&"'!A1", "Go to "&A1) Explain
Wrap sheet names in single quotes so names with spaces still work.
Common mistakes
- Forgetting the #. Without it, Excel looks for an external file instead of a sheet in this workbook.
- Hard to select. Clicking the cell follows the link. Click and hold, or use the arrow keys, to select it instead.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.