How to Insert Static and Dynamic Hyperlinks in Excel?

When we talk about hyperlinks in Excel, most users assume they are only used to open websites. In reality, hyperlinks can point to other worksheets, external files, email addresses, and even specific cells within a workbook. These links can be static or dynamically generated, depending on how they are created.

Example Workbooks

Let’s create two Excel workbooks to use as examples in this article:

WebNots_1.xlsx: This book contains four sheets named as Project schedule, Sheet1, Log, and About.
WebNots_2.xlsx: This book contains a single sheet named as Sheet1.

1. Inserting Static Links

Right-click any cell and select “Link > Insert Link…” option. Alternatively, press Ctrl + K shortcut keys or go to “Insert tab > Link”. This opens the “Insert Hyperlink” dialog box with multiple options.

Here are the things you can do:

Link to	How?	Example Use Case
Webpage	Existing File or Web Page → paste URL in the “Address” box.	Open a website such as https://www.webnots.com.
Another sheet in same workbook	Place in This Document → select a sheet → enter A1 as the cell reference.	Jump to Sheet1, cell A1.
Specific cell in same workbook	Place in This Document → enter cell number in “Type the cell reference” box.	Jump directly to cell E30.
Email address	E-mail Address → enter email and subject.	Send an email to [email protected] with subject.
Another Excel file	E-mail Address → enter email and subject.	Open WebNots_2.xlsx.
Specific cell in another Excel file	Insert Hyperlink dialog → select file → append cell reference in Address.	Open WebNots_2.xlsx and go to Sheet1!C5.
A new Excel file by creating afresh	Create New Document → provide a name and select path to save.	Create and edit new file.

By default, Excel shows the cell’s content as the link text. You can change it by editing the “Text to display” box to overwrite the cell’s content.

Note: Excel automatically turns typed URLs or email addresses into clickable links. For example, you can type https://www.webnots.com or [email protected] and press Enter to create a link. If you want to prevent auto-conversion, type an apostrophe first like ‘https://example.com. The apostrophe won’t show in the cell or on printouts.

2. Inserting Dynamic Links

If you need a hyperlink that updates based on cell values, the HYPERLINK function is the most suitable option. It can also be used to create static links, such as opening a webpage or composing an email. The function accepts two arguments: one required (link_location) and one optional (friendly_name), as shown below:

=HYPERLINK(link_location, [friendly_name])

The first argument link_location is a text string that tells Excel where to navigate when the link is clicked. Its structure varies depending on the target.

Internal links within the same workbook: Use local references to point to cells or named ranges inside the same workbook. The reference must begin with hash symbol (#) to indicate it is internal rather than external.

"#Sheet1!A1" → points to cell A1 in Sheet1.
"#NamedRange" → points to a defined name in the workbook.

External workbook references: Use full file paths to link to another workbook. You can optionally append a sheet and cell reference using #Sheet!Cell syntax to navigate directly to a location.

"C:\Folder\WebNots_2.xlsx" → opens the file.
"C:\Folder\WebNots_2.xlsx#Sheet1!B5" → opens the file and navigates to a specific location.

Web URLs: Use standard HTTP or HTTPS addresses to open web pages. Ensure the URL is properly formatted.

"https://www.webnots.com"

Email links: Use the mailto: protocol to create email links. You can include parameters such as subject or body in the query string.

"mailto:[email protected]?subject=Hello"

The second argument, friendly_name, controls the display text shown in the cell. This is optional and if omitted, Excel displays the link_location itself. This argument can be a text string such as “Click here”, a numeric value, or a cell reference allowing dynamic labels.

Here are some examples of HYPERLINK function using both first and second arguments:

For a clickable “Search Web” text.

=HYPERLINK("https://www.webnots.com", "Search Web")

Dynamically jumps to the sheet name typed in cell B1.

=HYPERLINK("#"&B1&"!A1", "Go to Sheet")

Links to cell A5 of Sheet1 in another WebNots_2 workbook (must be open, or full path required).

=HYPERLINK("[WebNots_2.xlsx]Sheet1!A5", "Open Another File")

You can also create a hyperlink to a named range for easier navigation within a workbook. First, select the desired range and go to the “Formulas” tab, then choose “Define Name” and assign a name such as “SummaryData”. After that, use the below formula to link directly to that range.

=HYPERLINK("#SummaryData", "Jump to Summary Data")

From a practical standpoint, HYPERLINK is often combined with other functions like CONCAT, TEXT, or CELL to dynamically generate navigation structures inside dashboards or reports.

Editing and Removing Links

Edit: Right-click the linked cell and select “Edit Hyperlink” to open the same “Insert Hyperlink” dialog. Now, you can change the previously linked item.
Remove: Right-click and select “Remove Hyperlink”, which will remove the link but keeps the text. You can also remove multiple links by selecting a range, right-click and choose “Remove Hyperlinks” option.