HYPERLINK
The HYPERLINK function creates a clickable link in a cell. It directs users to a website, file, email address, or a 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 🔗
Use the HYPERLINK function to add interactivity to your Excel sheet. It helps you create links to different locations, whether on the internet, in a document, or within the same workbook. This function allows you to turn text or cells into clickable links, improving the navigation and accessibility of your spreadsheet.
Examples 🔗
Link to a website: To create a hyperlink to www.example.com with the display text 'Visit Example', use the HYPERLINK formula: =HYPERLINK('http://www.example.com', 'Visit Example')
Link to a file: To link to a PDF file named 'report.pdf' stored on your desktop, 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', use: =HYPERLINK('#Sheet2!A1', 'Go to Sheet2')
Notes 🔗
Ensure that the link_location is specified correctly to direct you to the intended destination. Remember that HYPERLINK creates a clickable link only in the cell where you enter the formula. 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.