HYPERLINK Function

Summary

The HYPERLINK function creates a clickable link in a cell. That link can open a website, a file, an email address, or a location inside the current workbook.

This makes HYPERLINK useful when a workbook is more than just a calculation sheet. It can help users jump between sections, open supporting documents, or launch related actions such as sending an email.

HYPERLINK is useful because it turns worksheet output into an action. Instead of showing plain text, the formula can create something clickable, which helps reports, directories, dashboards, and navigation tables feel more connected and easier to use.

Syntax

=HYPERLINK(link_location, [friendly_name])

link_location is the destination, and friendly_name is the text the user sees in the cell. For example, =HYPERLINK("https://excelclash.com","Open Site") creates a clickable link with the label Open Site.

For links inside the same workbook, the location usually starts with #. That tells Excel the destination is internal, such as #Summary!A1.

Arguments

• link_location - The destination you want the link to open. This can be a web address, file path, email link, or internal workbook reference.
• [friendly_name] - Optional. The label shown in the cell instead of the full destination text.

If you leave out friendly_name, Excel usually shows the destination itself. In many worksheets, adding a short label such as "Open File" or "Go to Summary" makes the sheet much easier to read.

HYPERLINK vs Other Functions

HYPERLINK creates an action. Related functions may build text or return address information, but they do not create the click behavior by themselves.

Using HYPERLINK

One common use of HYPERLINK is workbook navigation. A summary sheet can contain links to reports, logs, dashboards, or data-entry sections so users do not need to scroll or search manually. For large workbooks, this can make the file much easier to use.

Another useful pattern is building the destination from other cells. A workbook might store a folder path in one cell and a file ID in another. HYPERLINK can join those parts into one file link. This is helpful when many links follow the same structure and only one piece of the path changes.

HYPERLINK is also useful for mailto links. Instead of only opening websites or files, it can open the default email app with a prepared address, subject, or other parameters. That can be a nice touch in trackers, approval sheets, and project dashboards.

• Use HYPERLINK for workbook navigation, external links, and file access.
• Use # for links inside the same workbook.
• Build the destination from cells when the path or address needs to change dynamically.

Example 1 - Link to Another Place in the Workbook

This formula creates an internal jump link. The # at the start tells Excel the destination is inside the current workbook. This is useful for menus, contents pages, and dashboard navigation.

This makes the example practical for large workbooks. Instead of scrolling through many sheets, the user can jump straight to the section they need with one click.

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

Example 2 - Create an Email Link

This example uses the mailto: format, so clicking the result opens the email app instead of a browser or worksheet location. It is useful when a sheet needs a fast way to contact a person tied to the current record.

That is especially helpful in HR, approval, or support trackers. The workbook becomes a small action hub instead of only a place to read data.

=HYPERLINK("mailto:hr@corp.com?subject=ID_101", "Email HR")

Example 3 - Open a File with a Dynamic Path

This pattern builds a file path from text and cell values. It is useful when the workbook stores document IDs and each ID should open a related file, such as a PDF invoice or drawing.

This shows why HYPERLINK works well with other formulas and cell references. The destination can change by record, while the link formula itself stays the same.

=HYPERLINK("N:/Vault/" & A1 & ".pdf", "Open Blueprint")

Example 4 - Build a Jump Link from Another Cell

Sometimes the destination is already stored in the sheet, and HYPERLINK just needs to turn it into a clickable result. This keeps the link logic flexible because the target can change without rewriting the formula itself.

That makes the sheet easier to maintain. A user can update the target cell, and the clickable link updates with it automatically.

=HYPERLINK("#" & B1, "Go to Latest")

Conclusion Recap

HYPERLINK is less about calculation and more about making a workbook easier to use. In this lesson, that meant jumping to another sheet, opening a website or file, and creating an email link from values already in the workbook.

What makes it especially useful is that the destination can be built from other cells. That means one formula can create links that change with the current record, file name, sheet name, or target location instead of staying fixed.

• Main job: HYPERLINK creates a clickable link in a cell.
• Common targets: Websites, files, email addresses, and internal workbook locations.
• Internal rule: Use # when linking inside the same workbook.
• Useful pattern: Build the destination from cells when the path or target should update dynamically.