How to use HYPERLINK Function in Excel

The Excel HYPERLINK function returns a hyperlink from a given destination and “friendly name”. You can use HYPERLINK to construct a clickable hyperlink with a formula. The HYPERLINK function can build links to workbook locations, pages on the internet, or to files on network servers.

Syntax:= HYPERLINK (link_location, [friendly_name])

The HYPERLINK function syntax has the following arguments:

  • Link_location    Required. The path and file name to the document to be opened. Link_location can refer to a place in a document — such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. The path can be to a file that is stored on a hard disk drive. The path can also be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet.Note   Excel for the web the HYPERLINK function is valid for web addresses (URLs) only. Link_location can be a text string enclosed in quotation marks or a reference to a cell that contains the link as a text string.If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.
  • Friendly_name    Optional. The jump text or numeric value that is displayed in the cell. Friendly_name is displayed in blue and is underlined. If friendly_name is omitted, the cell displays the link_location as the jump text.Friendly_name can be a value, a text string, a name, or a cell that contains the jump text or value.If friendly_name returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.

Example: Let’s look at some Excel HYPERLINK function examples and explore how to use the HYPERLINK function as a worksheet function in Microsoft Excel:

Syntax:  =HYPERLINK(B2,A2)

Result:

Based on the Excel spreadsheet above, the following HYPERLINK examples would return:

Syntax: =HYPERLINK(B3,A3)
Result: Google

Syntax: =HYPERLINK(B4,A4)
Result: Sheet2

Syntax: =HYPERLINK(B5,A5)
Result: Sheet3

Syntax: =HYPERLINK(B6,A6)
Result: HYPERLINK Function in Excel

Syntax: =HYPERLINK(B7,A7)
Result: excel-npv-function

Syntax: =HYPERLINK(B8,A8)
Result: excel-hyperlink-function

Note:

  • Link_location should be supplied as a text string in quotation marks or a cell reference that contains the link path as text.
  • If friendly_name is not supplied, the HYPERLINK will display link_location as the friendly_name.
  • To select a cell that contains HYPERLINK without jumping to the destination, use arrow keys to select the cell. Alternatively, click on the cell and hold the mouse button down until the cursor changes.

Add a Comment

Your email address will not be published. Required fields are marked *