What is the HYPERLINK Function in MS Excel?

This function is used to jump to a different location in the same workbook, a different worksheet, or a location on a network. When you click on the hyperlink given in a cell, then Excel will jump to the location given in the hyperlink function.

Purpose of HYPERLINK Function in Excel

The purpose of the HYPERLINK function in MS Excel is to jump to a different location. It can jump to a location in the current workbook. When you click on the hyperlink function in a cell, then Excel jumps to that location or opens the specific document.

Syntax of HYPERLINK Function

The syntax of the HYPERLINK function in MS Excel is as follows.

HYPERLINK (link_location, [friendly_name])

Arguments

The arguments for this function are described below.

Link_location: this is the complete path and filename of the document that you want to open through the HYPERLINK function. This argument is written as a text string in quotation marks. This can also be in the form o a reference to the cell containing a text string.

Friendly_name: this argument value is displayed in blue color and it is underlined as well. This is the text or numeric value to be displayed in the cell.

Examples

=HYPERLINK (“http://example.microsoft.com/report/budget report.xlsx”, “Click for report”)

The above-mentioned HYPERLINK function will jump to the mentioned URL and will open the linked page.