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.

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.

=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.

=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.

=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.

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

Conclusion Recap

• 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.