URL
Description
Converts a URL into a clickable link on a sheet.
Syntax
URL(
url
, [ label
],
[tooltip
]) - 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.
- tooltip: The text to display when the user hovers the cursor over the cell. If you don't include this argument, the function uses thelabelargument as the clickable text. You can use a cell reference to contain the tooltip.
Example
Formula | Result |
|---|---|
=URL("http://www.workday.com","Workday") | Workday (as a clickable link) |
=URL("http://www.workday.com","Workday","Open link in new browser
window") | Workday (as a clickable link), with a tooltip of "Open link in new browser
window" |
=URL("#"&REMOVEROWS(INFO("wd.sheet.names"))) | Creates a clickable list of links to the sheets of the workbook; this essentially
provides a Table of Contents of the workbook tabs. |
Notes
- This function is similar to the HYPERLINK 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 URL function; it becomes a link-formatted cell containing a URL.
Related Functions
HYPERLINK