How to Hyperlink to Cell in Excel (2 Simple Methods)

Situations may demand you to deal with links in Excel. Cases can be like find links, deal broken links, and many more. Today we are going to show you how to hyperlink to a cell. For this session, we are using Excel 2019, feel free to use your preferred version.

First things first, let’s get to know about the dataset that is the base of our examples.

Dataset - Excel Hyperlink To Cell

Here we have information regarding a few popular scorers. Their popular name and their details are stored in two distinct tables or lists. Using this dataset we will hyperlink to a cell.

Note that this is a basic dataset to keep things simple. In a practical scenario, you may encounter a much larger and complex dataset.

Practice Workbook

You are welcome to download the practice workbook from the link below.

Hyperlink to Cell

1. Hyperlink to Cell within Same Sheet

In this section, we will see how to hyperlink a cell within the same sheet. To demonstrate that, from our dataset, we will link the athlete’s popular name to the cell where his details are stored.

Example scenario - Excel Hyperlink To Cell

Let’s say clicking Ronaldo we will go to the cell of Cristiano Ronaldo. This will be the case for the other scorers as well. Let’s explore the methods.  

I. Excel Feature to Hyperlink to a Cell

Excel provides almost every feature for each of the operations that can be performed. A hyperlink is not an exception.

To hyperlink to a cell using the feature select the cell and right-click on it. You will find few options there. One of the options is Link.

Select Link to hyperlink to cell

Click the option Link. You can find the same option from the Link section in the Insert tab.

 

Select Link from Insert to hyperlink a cell

This will open the Insert Hyperlink dialog box. Explore the Place in This Document in this dialog box. There you will sheets’ names for the Excel file. Among the sheets, your active sheet will be selected by default.  

Insert Hyperlink dialog Box to set hyperlink

Insert the Cell Reference in the Type the cell reference field. Here E5 stores Cristiano Ronaldo so we have inserted that.

And then click OK. It will set the hyperlink to the desired cell.

Hyperlink to the cell

Click the link (B4 cell), it will take you to the cell (E5) that we have linked with it.

Demonstration of hyperlink

Drag Down with ALT Key 

We can hyperlink to the cell by dragging the destination cell to the source cell. Mere dragging may not be helpful, Press the ALT key and drag the cell down to another cell.

Drag and Down with ALT key

Here, we have dragged Lionel Messi by pressing the ALT key simultaneously to the B5 cell.

Now leave the ALT key and right-click on the mouse. Several options will appear in front of you.

Click Create Hyperlink Here

Click Create Hyperlink Here and it will hyperlink to the cell.

Hyperlink to the cell

Click the link to clarify.

Take to the linked cell

II. Excel HYPERLINK Function to Hyperlink to Cell

Excel provides a function called HYPERLINK that helps to hyperlink to a cell. This function returns a hyperlink from a given destination and link text. Syntax of this function is

HYPERLINK(link_location, [friendly_name])

To know more about the function visit the Microsoft Support site.

Let’s use the function to hyperlink to the cell.

=HYPERLINK("[Excel Hyperlink To Cell.xlsx]'Link - Same Sheet'!E7","Neymar")

HYPERLINK Formula to set link

We have set the cell as the link_location parameter. Typically we need to set to the entire location (name of the file following by sheet and cell). And used “Neymar” as the name.

This will set the hyperlink to the cell.

Hyperlink to cell through HYPERLINK Formula

Click the link or cell, it will take us to the destination cell.

Demonstration of hyperlink

Let’s hyperlink to the rest of the cells following the methods.

Hyperlink to all the cells

2. Hyperlink to Cell in Different Sheet

We can hyperlink cells across different sheets. Let’s say, we have the short names at the Link – Different Sheets.

Link - Different Sheets - Excel Hyperlink To Cell

And their details are in the Details sheet.

Details sheet - Excel Hyperlink To Cell

We will hyperlink to the cell across the sheets.

I. Excel Feature to Hyperlink to a Cell

The approach will be similar, open the Insert Hyperlink dialog box (any of the ways we have used in the earlier section).

Insert Hyperlink dialog box for different sheet

Now, from the Place in This Document select the Details sheet and insert the appropriate cell reference.

Then click OK. It will hyperlink to the cell.

Hyperlink to cell across sheets

Click the link, it will take you to the destination cell in the different sheet.

Destination cell clicking the link

II.HYPERLINK Function to Hyperlink to Cell

The HYPERLINK function also helps us hyperlinking to the cell from a different sheet. All you need to do is provide the correct sheet name within the function.

Let’s write the formula for Messi

=HYPERLINK("[Excel Hyperlink To Cell.xlsx]Details!B6","Messi")

HYPERLINK Formula to link across sheets

We are writing this formula from the Link – Different Sheets and here we have set the sheet name Details in the link. So, it will create a hyperlink.

Hyperlink to different sheet cell

Click the hyperlink, it will lead us to the destination cell.

Destination cell clicking the link

Let’s hyperlink to the rest of the cells. Practice makes a man perfect, haha!

Hyperlink to all cells across sheets

Conclusion

That’s all for the session. We have listed approaches to hyperlink to a cell in Excel. Hope you will find this helpful. Feel free to comment if anything seems difficult to comprehend. Let us know any other methods that we might have missed here.

Shakil Ahmed

My name’s Shakil. My articles are targeted to support you in enriching knowledge regarding different features related to Microsoft Excel. I am fond of literature, hope some knowledge from them will help me providing you some engaging articles even though some weary technical terms.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo