The HYPERLINK function allows you to build a link in a cell pointing to something else like a file, workbook, cell, cell range or a webpage.
You can then click on that link to open a file or quickly navigate to a location in a workbook.
Excel function syntax
Required. Depending on what you want to create a link to you have these options:
File - Full hard drive path to file and file name + file extension
File on a server - Full hard drive path to file and file name + file extension
File on the internet - HTTP/HTTPS address + filename and extension
Workbook - Full hard drive path to workbook and workbook name
Webpage - HTTP/HTTPS address
Bookmark in a word document
Optional. A value or a cell reference used by the HYPERLINK function to show link text, in the cell. This argument is optional, the HYPERLINK function displays the link location if the argument is missing.
To select a cell without performing the hyperlink action click and hold on the cell until a cross appears, see animated image below.
If you use a cell reference as an argument you can make the function dynamic. This allows the HYPERLINK function to change depending on the value in the cell that the cell reference points to.
Many of the articles shown below are built with that technique.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Articles with the 'HYPERLINK' Function
The following 4 articles have formulas that contain the HYPERLINK function.