Menu
EXCEL HYPERLINK FUNCTION
Excel HYPERLINK Function Introduction
This method generates a link that may be clicked.
Description of Excel HYPERLINK Function
Syntax:
=HYPERLINK (link_location, [friendly_name])
Parameter list:
- link location – the path to the to-be-opened file or page.
- friendly name – the link text to show in a cell, optional.
Use the HYPERLINK tool to build connections to workbook locations, internet sites, or files on network servers.
Excel will launch the file or page indicated by the link location when a user clicks a cell containing the HYPERLINK function. Link location can be a cell reference or named range, a path to a file on a local disc, a path to a file on a server in Uniform Naming Convention (UNC) format, or a route to a location on the internet or intranet in Uniform Resource Locator (URL) format.
Step By Step Guide of HYPERLINK Function
Example :
=HYPERLINK(“https://www.amazon.in/”,”Click Me”) will generate a link in Excel with the text Click me that, when clicked, will open the website amazon.com.
Key Points
- Link location should be specified as a text string surrounded by quotation marks or as a cell reference containing the link route as text.
- If no friendly name is specified, the HYPERLINK will use link location as the friendly name.
- To pick a cell that includes HYPERLINK without going to the destination, use the arrow keys. Click on the cell and hold down the mouse button until the pointer changes.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
