How to create HYPERLINK in Excel

This article helps to know how to put HYPERLINK in the excel sheet, the hyperlink can be from any cell, sheet or another website.

The Excel HYPERLINK function returns a hyperlink from a given destination and link text. You can use HYPERLINK to create a clickable hyperlink with a formula. The HYPERLINK function can build links to workbook locations, pages on the internet, or to files on network server

Purpose: Create a clickable link.  
Return value: A clickable hyperlink
Syntax: =HYPERLINK (link_location, [friendly_name])

Examples:

1. To link to another cell in the same worksheet, prefix the cell with “#”:
   =HYPERLINK("#Z100","link to Z100")
   note: cell is in from the same sheet
2. To link to another sheet in the same workbook, use “#” with the Sheet name like this=HYPERLINK("#Sheet2!A1","Sheet2")
   note: sheet2 is from same workbook
3. Excel sheet name with space:
   If the sheet name contains a space, this will give an invalid reference error with the formula above. In that case, you’ll need to enclose the sheet name in single quotes (‘) like this:
   =HYPERLINK("#'Sheet 2'!A1","Sheet 2")
4. To link to https://exceljet.net/ with the text “exceljet”:
   =HYPERLINK("https://exceljet.net/","exceljet")
5. To link to a valid email address in A1, you can concatenate “mailto:” like this:
   =HYPERLINK("mailto:"&A1,"email")

Download Excel or use Office 365 online to use Excel Hyperlink Function.