|
Home > Formulas > Lookup > Hyperlink Excel HYPERLINK Function Examples
|

Jump To
In this video I show a quick overview of how you can create clickable hyperlinks with Excel HYPERLINK formulas.
There are written steps and examples below the video
The Excel HYPERLINK function creates hyperlinks that can open a document, or jump to a specific location.
The HYPERLINK function has two arguments in its syntax:

For the HYPERLINK function, there is a 255 character limit when you build the Link_Location string.
Friendly_Name: In my tests, the 255 character limit DID NOT apply to the Friendly_Name argument.
In the screen shot below, there are company names in column A, and website addresses (URLs) in column B.
In C2, I wrote a HYPERLINK formula:
It creates a hyperlink that goes to the URL (from B2), and shows the website name(from A2)

With a HYPERLINK formula, you can link to a location in the current Excel workbook, or to another Excel file. This video shows the steps, and there are written steps below the video.
TIP: To follow along with this video, download the Hyperlink Examples Video workbook.
You can link to other Excel files that are in the same folder as the active file, or in a different folder.
To create a link to a different workbook, in the same folder, just use the file name as the link_location argument for the HYPERLINK function.
For files that are up a level or more in the hierarchy, use two periods and a backslash for each level.
=HYPERLINK("..\MyFileB.xlsx","FileB")
=HYPERLINK("..\..\MyFileA.xlsx","FileA")
Or, instead of typing the file path details in the HYPERLINK formula, you can refer to cells that contain the location text.
In the screen shot below, the formula in cell E3 refers to the address in C3, and the friendly name in cell D3:

You can use a HYPERLINK formula to create a link that goes to a cell or range somewhere within the current workbook.
Below, there are 6 examples for HYPERLINK formulas within the same workbook:
Start with a #, then type the sheet name and cell reference.
Optional - Type a friendly name, such as "Budget" to appear in the cell:
Tip: If the formula's hyperlink doesn't work, insert a temporary hyperlink in a blank cell, using the Ctrl + K shortcut. Use its location syntax as a guide to fixing your formula.
Use the & operator to create a link location.
In this example, the sheet name is in cell B5, the cell address is in C5, and the friendly name is in cell D5.
For a link to a workbook-level named range in the same workbook, just use the range name as the link location.
The examples in the following sections go beyond the basics. They show the power and versatility of the Excel HYPERLINK function.
Go to the empty cell at the end of:

In cell B1, the formula finds the first empty cell after the worksheet list in column A:
To find the empty row number, add the count of items in column A, plus the row number for the starting cell.

In cell E1, the formula finds the first empty cell after the named table in column D:
Here's how the formula works.
To find the empty row number, the formula calculates the SUM of:
In the screen shot below, the empty cell's row number is 7:

In some large Excel workbooks, I add hyperlinks that go to the previous sheet and next sheet quickly.
In the Sheet Navigation sample file, shown below, each sheet has hyperlinks created with the HYPERLINK function.

On a worksheet named Lists, there are two things that help the navigation system work:

For sheet navigation, there are formulas in columns A (visible) and B (hidden)

Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.
Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!
Last updated: August 19, 2026 4:07 PM