Create a shortcut of a given path in Excel
Creates a shortcut that opens a document on your hard drive, a server, or the Internet


Create a clickable hotlink of a given path.


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.


= HYPERLINK(link_location, [friendly_name])


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:

Switch reference data from rows to columns or vice versa in Excel


The TRANSPOSE function “switch data direction” or the range of data from vertical format (row) to horizontal format (column), or vice versa.

Read More »
To display formula as text in Excel


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”.

Read More »