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

Taught hands-on in Level 4: Advanced Dynamic Arrays & Logic · Reference Functions module

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

ArgumentRequired?What it does
link_locationYesThe URL, file path or in-workbook location (starting with #) to open.
friendly_nameOptionalThe 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)
AB
1MarchGo 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

Kyle Stott

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.