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.
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.
You are welcome to download the practice workbook from the link below.
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.
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.
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.
Click the option Link. You can find the same option from the Link section in the Insert tab.
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 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.
Click the link (B4 cell), it will take you to the cell (E5) that we have linked with it.
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.
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 and it will hyperlink to the cell.
Click the link to clarify.
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
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")
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.
Click the link or cell, it will take us to the destination cell.
Let’s hyperlink to the rest of the cells following the methods.
We can hyperlink cells across different sheets. Let’s say, we have the short names at the Link – Different Sheets.
And their details are in the Details sheet.
We will hyperlink to the cell across the sheets.
The approach will be similar, open the Insert Hyperlink dialog box (any of the ways we have used in the earlier section).
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.
Click the link, it will take you to the destination cell in the different sheet.
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")
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.
Click the hyperlink, it will lead us to the destination cell.
Let’s hyperlink to the rest of the cells. Practice makes a man perfect, haha!
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.