HYPERLINK

Excel Functions

Create a clickable link.

Syntax

EXCEL

=HYPERLINK(link_location, [friendly_name])

Arguments

Parameter	Description
`link_location`	The path to the file or page to be opened.
`friendly_name`	[optional] The link text to display in a cell.

Return Value

A clickable hyperlink

Details

The HYPERLINK function creates a hyperlink to a given destination with a "friendly name", which is simply the anchor text. You can use HYPERLINK to construct a clickable hyperlink with a formula. The HYPERLINK function can build links to other cells in a workbook, other sheets, named ranges, other workbooks, pages on the internet, or files on network servers. You can also use HYPERLINK to create email links. The HYPERLINK function takes two arguments: link_location and friendly_name. Link_location is the destination or path the link should follow, entered as text. Friendly_name is the text that will be displayed with the link. When a user clicks a cell that contains the HYPERLINK function, Excel will open the file or page specified by link_location. Link_location can be a cell reference or

Examples

Example #1 - link to cell

To link to another cell in the same worksheet, prefix the cell with "#":

EXCEL

=HYPERLINK("#Z100","link to Z100") // cell in same sheet

Example #2 - link to sheet

To link to another sheet in the same workbook, use "#" with the Sheet name like this

EXCEL

=HYPERLINK("#Sheet2!A1","Sheet2") // sheet2 in same workbook

Example #2 - link to sheet

If the sheet name contains a space, you'll get an invalid reference error with the formula above. In that case, you'll need to enclose the sheet name

EXCEL

=HYPERLINK("#'Sheet 2'!A1","Sheet 2") // sheet name with space

Example #3 - external link

To link to https://exceljet.net/ with the text "exceljet":

EXCEL

=HYPERLINK("https://exceljet.net/","exceljet")

Example #4 - email link

To link to a valid email address in A1, you can concatenate "mailto:" like this:

EXCEL

=HYPERLINK("mailto:"&A1,"email") // link to email address in A1

Example #4 - email link

With two email addresses in A1 and A2, you can create a link like this:

EXCEL

=HYPERLINK("mailto:"&A1&","&B1,"email") // two emails