Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

HYPERLINK

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

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:

To display formula as text in Excel

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

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

TRANSPOSE

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

Read More »