Excel HYPERLINK Function

HYPERLINK creates a clickable link inside a cell and returns the display text you choose for it. Click the cell and Excel jumps to whatever you pointed it at: a webpage, a file, an email address, or a cell somewhere else in the workbook. The one thing to know up front: if the destination doesn't exist, the formula won't show an error until someone actually clicks it.

Available in: Excel 365, Excel 2021, Excel 2019, and all earlier versions back to Excel 2000. In Excel Online, HYPERLINK only works for web addresses, not internal cell or sheet navigation.

Syntax

=HYPERLINK(link_location, [friendly_name])

Parameter	Required	Description
link_location	Yes	Where the link goes. Can be a web address, a file path, an email address (using mailto:), or a reference to a cell, range, or sheet in the current workbook.
friendly_name	No	The text or number displayed in the cell. If you leave this out, Excel displays link_location itself, full path and all.

Basic Example

You're building a document tracker where column A holds full file paths and you want a clean "Open File" button instead of the raw path showing.

=HYPERLINK(A2, "Open File")

// A2            = the file path, something like C:\Reports\Q3_Summary.xlsx
// "Open File"   = the text that actually displays in the cell

The cell shows "Open File" in blue, underlined text. Click it, and Excel opens Q3_Summary.xlsx directly, no need to dig through folders. The path in A2 stays hidden from view, which keeps the sheet readable even when the underlying paths are long.

How HYPERLINK Works

It displays text, but stores a destination

The cell shows friendly_name, but the actual click behavior comes from link_location. These can be completely different. A cell can display "Visit our site" while the link underneath points to https://example.com. You can't see the destination unless you click the cell or check the formula bar.

It can link within the same workbook

To jump to a cell on another sheet, prefix the reference with # and use the sheet name:

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

The # tells Excel this is an internal reference, not an external file or URL. Without it, Excel treats Summary!A1 as a file path and the link breaks.

It can build the link from other cells

Instead of typing a fixed address, you can concatenate cell references into link_location. This is what makes HYPERLINK genuinely useful in dashboards and trackers rather than a one-off gimmick: the formula updates the destination automatically as your data changes.

=HYPERLINK("#" & B5 & "!A1", "Jump to " & B5)

// B5 holds a sheet name, like "Region_West"
// The formula builds a live reference to cell A1 on whatever sheet B5 names

It works with email addresses

Prefix the address with mailto: and HYPERLINK opens the user's default email client with the address pre-filled:

=HYPERLINK("mailto:sales@company.com", "Email Sales")

You can even pre-fill a subject line by appending ?subject= to the address.

Common Use Cases

Build a clickable document index

You keep a master list of report file paths in column A and want one-click access from a summary sheet.

=HYPERLINK(A2, LEFT(A2, FIND(".", A2) - 1))   // shows the file name without the extension as the clickable text

Link each row to its detail sheet in a workbook

You have 12 monthly sheets named Jan, Feb, Mar, and so on, and want a navigation column on a summary tab.

=HYPERLINK("#" & B2 & "!A1", B2)

// B2      = the sheet name for that row, e.g. "Jan"
// "!A1"   = jumps to cell A1 on that sheet
// B2      = also used as the display text, so the label matches the sheet name

Create a mailto link with a pre-filled subject

You're sending status reports and want reviewers to click straight into a pre-addressed email.

=HYPERLINK("mailto:manager@company.com?subject=Weekly Status Report", "Send Report")

Combine HYPERLINK with a lookup to jump to a matching record

You're tracking customer records across multiple sheets, and want a search cell that jumps directly to the matching row.

=HYPERLINK("#Records!A" & MATCH(E2, Records!A:A, 0), "View Record")

// E2                       = the customer ID you're searching for
// MATCH(...)               = finds the row number where that ID lives on the Records sheet
// "#Records!A" & row       = builds the jump target dynamically

Handling Errors

HYPERLINK itself rarely throws a formula error. It calculates and displays text even when the destination is invalid, and Excel only surfaces the problem when someone clicks the link and can't reach it. That includes malformed internal references, like a spaced sheet name missing its quotes: the formula still calculates fine and shows the friendly text, but the link itself won't resolve when someone clicks it.

Common causes of a broken link (not a formula error, a click-time failure):

• You (or a teammate) moved, renamed, or deleted the file after creating the link
• Someone renamed the sheet after you wrote the formula
• A sheet name containing a space wasn't wrapped in single quotes
• A network path is no longer accessible from the current machine
• The URL has a typo or the site no longer exists

=HYPERLINK("#'Q3 Results'!A1", "Go to Q3 Results")

// Sheet name "Q3 Results" contains a space, so it must be wrapped in single quotes
// Skip the quotes and the formula still calculates fine, but the link won't resolve when clicked

Notes & Gotchas

How do I create a hyperlink in Excel?

Press Ctrl+K for a one-off link. The dialog that opens lets you pick a file, webpage, or a location in the current workbook. But if the link needs to update automatically, based on other cells or a lookup, skip the dialog and use the HYPERLINK function instead. The dialog creates a static link. The function creates a formula that recalculates.

What is the HYPERLINK function in Excel and how do I use it?

HYPERLINK takes a destination and an optional display label, then returns a clickable cell. The syntax is =HYPERLINK(link_location, friendly_name): link_location is the address, friendly_name is what you want visible. Think of it as the formula-based alternative to manually inserting links through the dialog. That distinction matters the moment your destination needs to change based on other data.

How do I hyperlink to another sheet or cell within the same Excel workbook?

Put a # before the reference, then the sheet name, an exclamation point, and the cell: =HYPERLINK("#Summary!A1", "Go to Summary"). Sheet name has a space? Wrap it in single quotes: "#'Sales Report'!A1". Skip the # or forget the quotes on a spaced sheet name, and that's the most common reason this breaks.

How do I remove or delete hyperlinks in Excel?

Right-click the cell and choose "Remove Hyperlink" to delete a link you created through the Insert Hyperlink dialog. This clears the link but keeps the text. For links built with the HYPERLINK formula, you need to delete or overwrite the formula itself, since the link lives inside it rather than as a separate cell property. To strip links from an entire range at once, select the cells, right-click, and choose "Remove Hyperlinks" from the menu.

Why are my hyperlinks not working or updating in Excel?

Formula-based links break when the underlying reference changes. A file gets moved, a sheet gets renamed, a network drive gets remapped, and the formula has no idea. HYPERLINK doesn't validate the destination when it calculates, so a broken link looks perfectly normal until someone clicks it. Check the source cells feeding link_location first. That's almost always where the break started.

Does HYPERLINK work the same way in Excel Online?

No. Excel Online only supports HYPERLINK for web addresses. Internal navigation to another cell or sheet, using the # syntax, doesn't work in the browser version even though the same formula calculates fine in desktop Excel. If your workbook needs to run in a browser, build external URL links only, or expect the internal jumps to fail for anyone opening it online.

What happens if I use HYPERLINK without the friendly_name argument?

Excel displays the raw link_location text in the cell instead of a clean label. For a long file path or URL, expect the whole address to show, cluttered and possibly overflowing the column. Always supply friendly_name in shared workbooks so the display stays readable.

Related Functions

Function	Use this when...
VLOOKUP	You need to find a matching row before building a dynamic link target with HYPERLINK.
HLOOKUP	Your lookup table runs across a row instead of down a column, and you still want to build a link from the result.