How to use HYPERLINK function in Excel?

The HYPERLINK function in Excel is used to create a clickable link to a webpage, document, or other location. The general syntax of the HYPERLINK function is:

HYPERLINK(link_location, [friendly_name])
  • link_location: This is the URL or path to the file you want to link to. It can also be a cell reference if you want to link to another location within the same workbook.
  • friendly_name: This is an optional argument that allows you to specify the text that will be displayed in the cell. If omitted, the cell will display the link_location as the clickable text.

Here’s how you can use the HYPERLINK function:

   =HYPERLINK("http://www.example.com", "Visit Example Website")
  • Link to a Website:

In this example, clicking on the text “Visit Example Website” in the cell will take you to “http://www.example.com”.

   =HYPERLINK("C:DocumentsReport.xlsx", "Open Report")
  • Link to a File:

This will create a link that opens the “Report.xlsx” file located in the “Documents” folder when you click on “Open Report”.

   =HYPERLINK("#Sheet2!A1", "Go to Sheet 2")
  • Link to a Different Cell in the Same Workbook:

Clicking on “Go to Sheet 2” will take you directly to cell A1 on Sheet2 of the current workbook.

  • Link Using a Cell Reference for Location:

Assume cell B1 contains a URL, you can create a link like this:

   =HYPERLINK(B1, "Visit Linked Site")

This will create a hyperlink using the URL stored in cell B1, and “Visit Linked Site” will be displayed as the clickable text.

By using the HYPERLINK function, you can create efficient and user-friendly links within your worksheets, making it easier to navigate or access external resources.

Unlock Your Potential

Excel

Basic - Advanced

Access

Access Basic - Advanced

Power BI

Power BI Basic - Advanced

Help us grow the project