Hyperlink in excel to another worksheet

The HYPERLINK function creates a hyperlink to a given destination with a "friendly name", which is simply the anchor text. You can use HYPERLINK to construct a clickable hyperlink with a formula.

The HYPERLINK function can build links to other cells in a workbook, other sheets, named ranges, other workbooks, pages on the internet, or files on network servers. You can also use HYPERLINK to create email links.

The HYPERLINK function takes two arguments: link_location and friendly_name.

Link_location is the destination or path the link should follow, entered as text. Friendly_name is the text that will be displayed with the link.

When a user clicks a cell that contains the HYPERLINK function, Excel will open the file or page specified by link_location.

Link_location can be a cell reference or named range, a path to a file stored on a local drive, a path a file on a server using Universal Naming Convention (UNC), or an internet path in Uniform Resource Locator (URL) format.

Example #1 - link to cell

To link to another cell in the same w

how to remove hyperlink formula in excel

how to copy hyperlink formula in excel