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 named range, a path to a file stored on a local drive, a path a file on a server using Universal Naming Convention (UNC), or an internet path in Uniform Resource Locator (URL) format.
Example #1 - link to cell
To link to another cell in the same worksheet, prefix the cell with “#”:
Example #2 - link to sheet
To link to another sheet in the same workbook, use “#” with the Sheet name like this 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 in single quotes (’) like this:
Example #3 - external link
To link to https://exceljet.net/ with the text “exceljet”:
Example #4 - email link
To link to a valid email address in A1, you can concatenate “mailto:” like this: With two email addresses in A1 and A2, you can create a link like this: This formula example explains how to construct a more complete mailto email link with cc, subject, body, etc.
Notes
Link_location should be supplied as a text string in quotation marks or a cell reference that contains the link path as text. If friendly_name is not supplied, the HYPERLINK will display link_location as the friendly_name. To select a cell that contains HYPERLINK without following the link, use arrow keys or right-click the cell.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
