Rational
Create a clickable hotlink of a given path.
Description
The Excel HYPERLINK function creates a shortcut or clickable link of a given location with a “friendly name”. Once a user clicks on the link, it initiates the action of opening a new workbook, a file or folder on a hard disk or server, or a web page.
Syntax
= HYPERLINK(link_location, [friendly_name])
Parameters
link_location – The location or address to open.
friendly_name [optional] – Name of the link_location to display.
Return Value
A shortcut to a specific location
Key Notes
- You can use HYPERLINK function to initiate a call for action like opening an Excel workbook, any file or a folder, download a file, open a web page, and other related tasks.
- If the friendly_name option is empty, then link_locationis displayed to a user. So you can add a custom name or custom message while hovering that is meaning full to users.
- In case the link_location argument of address is not valid the Excel will return an error through a dialogue box pop up mentioning “Cannot open the specified file”.
Keep Reading Similar Functions:
TRANSPOSE
The TRANSPOSE function “switch data direction” or the range of data from vertical format (row) to horizontal format (column), or vice versa.
FORMULATEXT
The FORMULATEXT function displays the syntax of a reference cell as a string, cell B5 contains =5+2 return 7, = FORMULATEXT(B5) returns a text value “=5+2”.
