HYPERLINK

“HYPERLINK”

Used for – “HYPERLINK” function in MS Excel is used in the same manner as we add hyperlink by using link commands via insert tab> link group> link command i.e. it creates a shortcut / jump that opens a specific document which stored on network server / internet / intranet. And when you click on the link it will opens that file for which link have been created.

Syntax –HYPERLINK (link_location, [friendly_name])

            link_location – It is a path and file name of the document which we want to open using this formula. This path can be to a file that is stored on a hard disk drive or on intranet or internet. This path can also be a UNC (Universal Naming Convention) path on a server or a URL (Uniform Resource Locator) path on the Internet or an intranet. It can also be refer to a place in a document – such as specific bookmark in a word on cell/name range in a excel worksheet or workbook. It is also a compulsory field and if you did not fill any value excel consider it as 0 and does not give any error.

            [friendly_name] – It is an optional field and It can also be refer as jump text. It can be a text or a numeric value that will be displayed in the cell in blue color and is underlined. If friendly_name is not given then the cell displays the link_location as the friendly_name / jump text.

Example – Following example will clear some concept of HYPERLINK function:- 

Here Column A shows the Name which we want to display in Hyperlink and Column B Shows the Destination location of the file or site which we want to open on click and column C shows how to write HYPERLINK formula to get the result. You can write the formula directly as shown in Column D which will also give the same result.

	A	B	C	D	E
1	Display Name	Destination Location	Formula
2	Excelwithease	http://excelwithease.com	=hyperlink(B2,A2)	=HYPERLINK(“http://excelwithease.com”,”Excelwithease”)
3	Example	https://goo.gl/HPv7Fm	=hyperlink(B3,A3)	=HYPERLINK("https://goo.gl/HPv7Fm”,”Example”)
4
5
6
7

 And result you get as under:-

	A	B	C	D	E	F
1	Display Name	Destination Location	Formula	Direct Formula
2	Excelwithease	http://excelwithease.com	Excelwithease	Excelwithease
3	Example	https://goo.gl/HPv7Fm	Example	Example
4
5
6
7

This is how a HYPERLINK function work in excel and results in the text what we want to see and links to the address what we want to use.

• Tweet
• Share
• Share
• Share
• Share