HYPERLINK
The HYPERLINK function creates a clickable hyperlink in a cell. It is used to direct users to a specific website, file, email address, or cell reference within the spreadsheet.
Syntax 🔗
=HYPERLINK(link_location, [friendly_name])
link_location | The address of the destination. This can be a URL, file path, email address, or cell reference. |
friendly_name (Optional) | The text to display as the clickable hyperlink. If omitted, the link_location will be displayed. |
About HYPERLINK 🔗
When you need to add interactivity to your Excel sheet, the HYPERLINK function comes to the rescue. It's like a digital signpost that guides users to different locations, be it on the internet, in a document, or even within the same workbook. With HYPERLINK, you can create dynamic navigation paths, enhancing the usability and accessibility of your spreadsheet by transforming text or cells into clickable links.
Examples 🔗
Link to a website: Suppose you want to create a hyperlink to www.example.com with the display text 'Visit Example'. The HYPERLINK formula would be: =HYPERLINK('http://www.example.com', 'Visit Example')
Link to a file: If you want to link to a PDF file named 'report.pdf' stored on your desktop, you can use: =HYPERLINK('C:/Users/YourUsername/Desktop/report.pdf', 'Report PDF')
Link within the spreadsheet: To link to cell A1 in Sheet2 of the same workbook with the displayed text 'Go to Sheet2', you can use: =HYPERLINK('#Sheet2!A1', 'Go to Sheet2')
Notes 🔗
Ensure that the link_location is specified correctly to direct users to the intended destination. Remember that HYPERLINK creates a clickable link only in the cell where the formula is entered. If you copy the cell containing the function, the hyperlink will be copied too.
Questions 🔗
Yes, HYPERLINK can be used to create clickable email links. Simply enter the email address as the link_location, and users can click on it to open their email client with a new message.
Can HYPERLINK be applied to multiple cells at once?Unfortunately, HYPERLINK must be inserted into each cell individually where you want the hyperlink to appear. It does not automatically propagate to adjacent cells like regular data.
How can I remove a hyperlink created by the HYPERLINK function?To remove a hyperlink, you can clear the cell contents or overwrite the cell with different data. Simply deleting the formula may not remove the hyperlink display.