HYPERLINK
Description
Converts a URL into a clickable link on a sheet.
Syntax
HYPERLINK(
url
, [ label
]- url: The URL. For linking within a workbook, precede the path with a pound sign (#).
- label: The clickable text to display in the cell. If you don't include this argument, the function uses theurlargument as the clickable text. You can use a cell reference to contain the label.
Example
Formula | Result |
|---|---|
=HYPERLINK("http://www.workday.com","Workday") | Workday (as a clickable link) |
=HYPERLINK("#"&REMOVEROWS(INFO("wd.sheet.names"))) | Creates a list of clickable links to the sheets of the workbook, excluding the current sheet. |
=IFERROR(HYPERLINK(F1),"None") | Cell F1 displays the text None if an error occurs in the HYPERLINK function. |
Notes
- This function is similar to the URL function; however, to maintain compatibility with Excel, HYPERLINK doesn't have the optional tooltip argument.
- Keep in mind that if you use the right-click (context) menu in a Microsoft® Excel® workbook to create a hyperlink, and then you upload the workbook to Worksheets, it isn't converted into a HYPERLINK function; it becomes a link-formatted cell containing a URL.
Related Functions
URL