“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
|
||||
3
|
Example
|
https://goo.gl/HPv7Fm
|
||||
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.