HYPERLINK Function Explained
The HYPERLINK function in Microsoft Excel creates a hyperlink to a file, folder, or web page. It takes two arguments: the link_location and the friendly_name. The link_location is the path to the file, folder, or web page, and the friendly_name is the text that will be displayed in the cell. When clicked, the hyperlink will open the specified file, folder, or web page.
HYPERLINK Function Syntax
HYPERLINK(link_location, [friendly_name])
- link_location: The web address or file location that you want to link to.
- friendly_name: (optional) The name that you want to display in the cell. If this argument is omitted, the cell displays the link_location text.