Rational
Create a shortcut of a given path.
Description
The Excel HYPERLINK function create a shortcut or clickable link of a given location with a “friendly name”. Once a user clicks on the link, it initiates an 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_nameoption is empty, then link_locationis displayed to a user.
- In case the link_location argument of address is not valid the Excel will return 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”.