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:
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”.
TRANSPOSE
The TRANSPOSE function “switch data direction” or the range of data from vertical format (row) to horizontal format (column), or vice versa.
