A hyperlink can also be created using the worksheet function HYPERLINK():
HYPERLINK(link_location, [friendly_name])
- link_location — the path and file name of the document to be opened. The address can refer to a place within a document, for example, a specific cell or a named range in an MS Excel workbook, or a bookmark in an MS Word document. The path may be a file path on a hard disk, a UNC server address (in MS Excel for Windows), or a URL address on the Internet or intranet.
- friendly_name — the text to display for the link or a numeric value shown in the cell. The name appears in blue and underlined. If this argument is omitted, the cell displays the link_location as the link text.
NOTE
The arguments of the HYPERLINK() function can be either text expressions or cell references.
For example, if in the workbook Department.xlsx you need to go from cell B3 to cell A20 of the worksheet Report (cell B3 may itself be on the Report sheet, so movement is possible both within one sheet and between sheets), then you would enter the following hyperlink in cell B3:
=HYPERLINK("[Department.xlsx]Report!A20","Go to report")
or the formula:
=HYPERLINK(A1,B1)
where cell A1 contains [Department.xlsx]Report!A20, and cell B1 contains Go to report.
The first of the following two hyperlinks opens the workbook Sales.xlsx located in the root directory of drive D:, while the second opens the workbook and activates the worksheet May:
=HYPERLINK("D:\Sales.xlsx","Sales")
=HYPERLINK("[D:\Sales.xlsx]May!A1","Sales")
A hyperlink to the Russian-language Microsoft webpage can be created as follows:
=HYPERLINK("http://www.microsoft.com/ru/ru/","Microsoft")