HYPERLINK
Creates a clickable hyperlink to a URL, file, or location in the workbook.
HYPERLINK(link_location, [friendly_name])Arguments
link_locationURL or file pathfriendly_nameDisplay text(optional)
=HYPERLINK("https://example.com","Click here")Link to website
=HYPERLINK("#Sheet2!A1","Go to Sheet2")Link within workbook
=HYPERLINK("mailto:"&A1,A1)Creates email link
- •Use # prefix for internal workbook links
- •Supports mailto: for email links
- •Can link to files on network drives
- •Forgetting to wrap the link_location in quotes when it's a literal URL or file path rather than a cell reference, which raises a formula error
- •Using a relative file path for link_location that only works from the original computer or folder structure, breaking the link entirely once the file is shared or moved
- •Not realizing HYPERLINK's optional friendly_name argument only changes the displayed text - clicking the cell still navigates to link_location, so a mismatched friendly_name can mislead whoever clicks it
CONCATENATEOften used to build a dynamic link_location string for HYPERLINK from separate pieces of text, like a base URL and an ID.CELLCan retrieve information about the current file's path, sometimes useful when constructing relative HYPERLINK references.TEXTSometimes used to format a value before inserting it into a dynamically built HYPERLINK URL.Why does my HYPERLINK formula show an error?
The link_location is probably missing quotes around a literal URL or path - text values need to be wrapped in quotation marks, like "https://example.com", unless you're referencing a cell instead.
Can HYPERLINK link to another sheet or cell in the same workbook?
Yes, use a location reference like "#Sheet2!A1" as link_location, with the # prefix indicating an internal workbook reference.
Does changing friendly_name change where the link goes?
No, friendly_name only controls the displayed text in the cell - the actual destination is entirely determined by link_location, so they can end up out of sync if edited separately.
Need to translate a formula using HYPERLINK?
Use our translator to convert your complete formula