Contact
12 programs
Explore the site

HYPERLINK Function in Microsoft Excel: Syntax, Examples & Troubleshooting

Lookup and Reference Intermediate Microsoft Excel

Build clickable Excel links with HYPERLINK, separate destination from display text, maintain a link register and understand desktop versus web destination support.

Verification status: See the evidence and test scope described in this guide. How formula examples are checked

Quick answer: HYPERLINK(destination, label) puts a clickable link in a cell. The first argument identifies the destination; the optional second argument controls the visible text. A friendly label does not change where the link goes or prove that the target exists.

Syntax and arguments

=HYPERLINK(link_location, [friendly_name])

link_location is required and can be quoted text or a reference to a cell containing a destination. Excel desktop supports locations such as web addresses, workbook locations and files, subject to platform and access. Microsoft explicitly restricts Excel for the web to web addresses (URLs). Windows UNC network paths are documented as a Windows option, not a universal path format for every Excel platform.

friendly_name is optional. It can be text, a number, a cell reference or another value. If omitted, the destination itself is shown. If the friendly-name expression returns an error, Excel displays that error in place of the label.

Worked example: a small reference register

Enter the following in A1:B3:

Row A · Destination B · Label
1 Destination Label
2 https://support.microsoft.com/en-us/excel Excel help
3 https://www.spreadsheet-tutorials.com/excel/functions/sum/ SUM guide
  1. In C2 enter =HYPERLINK(A2,B2).
  2. The expected visible text is Excel help, with A2 as the destination.
  3. Copy the formula to C3. Its expected visible text is SUM guide, with A3 as the destination.
  4. Inspect the destination before opening a link, especially when the source table comes from someone else.

These are formula-display and destination expectations, not a claim that a browser was opened from Excel. Opening a target depends on connectivity, access, browser handling and the service’s current behavior. A readable label is not a test of those dependencies.

Second example: omit the friendly name

=HYPERLINK(A3)

The expected displayed text is the URL stored in A3. Compare it with =HYPERLINK(A3,"Read the SUM guide"), whose expected display is Read the SUM guide while the destination stays the same. This separation is useful when a long URL would make a worksheet unreadable.

For an error control, =HYPERLINK(A3,1/0) is expected to display #DIV/0! because the label expression itself fails. Troubleshoot that expression before blaming the web address.

Advanced application: maintain one destination centrally

Suppose several worksheet sections all link to the same reference. Put its address in Z1 and use:

=HYPERLINK($Z$1,"Reference manual")

Copy this formula to the relevant sections. The expected display remains Reference manual and every copied formula continues to use Z1. Editing the destination in Z1 updates the formulas’ target consistently; it does not edit the remote document or grant readers permission to open it.

For a row-by-row register, use relative destinations such as A2, A3 and A4 instead. Absolute and relative references solve different maintenance problems. Review the last copied formula to make sure a central reference did not slide down a column unintentionally.

Desktop workbook destinations

Microsoft also documents links to workbook sheets and named ranges. For example, if an accessible workbook is actually named Book1.xlsx and contains a January sheet, the documented pattern =HYPERLINK("[Book1.xlsx]January!A10","Go to January") targets its A10 cell and displays Go to January. Adapt both names to the real workbook rather than assuming the demonstration filename exists.

Do not use that pattern as an Excel-for-the-web guarantee: the vendor expressly limits web HYPERLINK destinations to URLs. Likewise, a Windows local drive or UNC share may be inaccessible on a colleague’s Mac or through a browser even if the same label looks correct.

Troubleshooting and safety checks

  • A link displays correctly but fails when clicked: Microsoft distinguishes formula display from successful navigation. Verify that the destination exists and that the current user has access.
  • The wrong destination opens: inspect link_location; a label such as “Company report” can point anywhere.
  • An error replaces the label: calculate the friendly-name expression separately and correct its error.
  • Selecting a cell opens the link: in desktop Excel, Microsoft’s selection guidance is to hold the mouse button until the pointer becomes a cross, then release. The web interface distinguishes an arrow pointer for selection from a pointing hand for navigation.
  • Unsafe or surprising links: avoid opening unfamiliar destinations merely because they arrived inside a workbook. HYPERLINK is navigation, not validation or content sanitization.

Compatibility and verification

Microsoft’s reference checked on October 17, 2026 lists: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016. This current support list does not establish the first release. The introduction version and last functioning version have not been established from the reviewed documentation. No retirement is asserted.

Example verification: Expected numerical results are independently calculated; text and shape expectations follow the documented contract. These examples have not been tested in Microsoft Excel. No screenshot or native execution is claimed.

ADDRESS in Excel | CONCAT in Excel | IFERROR in Excel