How to Link Cells in Same Excel Worksheet (4 Quick Ways)

Excel worksheet provides us with many features that help us to organize our data easily. Sometimes, for better analysis, we require Link Cells in our worksheet. We can link cells in the same excel worksheet as well as link cells from different worksheets. In the following article, we will learn how to link cells in the same excel worksheet.


Download Practice Book

Download the Practice Book.


4 Easy Ways to Link Cells in the Same Excel Worksheet

1. Link Cells in Same Excel Worksheet with Help of Paste Link

Linking cells in the same worksheet will save your time when you try to duplicate any cell value. One of the ways to link cells in a worksheet is to use the Paste Link option. In the first place, we will introduce the dataset. Here, we have a dataset of three columns. These are Employee, Working Hour & Salary. The overview of the dataset is given below. The same dataset will be used in all methods.

Link Cells in Same Excel Worksheet with Help of Paste Link

Follow the steps to learn this method.

STEPS:

  • In the beginning, select the cell that you want to link. We have selected Cell D8 here.

Link Cells in Same Excel Worksheet with Help of Paste Link

  • Then, copy the selected cell. You can right-click the mouse or simply press Ctrl + C to copy.
  • Now, select another cell where you want to link Cell D8. Here, we selected Cell B12 for this purpose.

Link Cells in Same Excel Worksheet with Help of Paste Link

  • Next, go to the HOME tab and select Paste. Then, select Paste Special from the drop-down menu.

Link Cells in Same Excel Worksheet with Help of Paste Link

  • Alternatively, you can choose Paste Special by right-clicking the mouse.

Link Cells in Same Excel Worksheet with Help of Paste Link

  • After that, a Paste Special window will appear. Select Paste Link from the window.

Link Cells in Same Excel Worksheet with Help of Paste Link

  • Finally, you will see the link cell in Cell B12.

Link Cells in Same Excel Worksheet with Help of Paste Link

Read more: How to Link Two Cells in Excel (6 Methods)


2. Link Cells Manually in Excel Worksheet

You can link cells manually in your excel worksheet very easily. This is the fastest way to link any cell in the same worksheet. To explain this method, we will use the same dataset.

Observe the steps to know this method.

STEPS:

  • Firstly, select a cell where you want to link. In this case, we have selected Cell B12.
  • Secondly, type ‘=’ (equal sign).

Link Cells Manually in Excel Worksheet

  • Now, select the cell you want to link. Here, we have selected Cell D8.

Link Cells Manually in Excel Worksheet

  • Finally, hit Enter to see the desired result.

Link Cells Manually in Excel Worksheet

Read More: How to Link Multiple Cells from Another Worksheet in Excel (5 Easy Ways)


3. Range of Cells Linking in Same Excel Worksheet

In the first two methods, we have described the way to link a single cell. But sometimes we need to link a range of cells. We will show how you can link a range of cells in the following method.

Pay attention to the steps for more.

STEPS:

  • Select the range of cells at first. We have selected the form Cell B8 to Cell D8.

  • Now, copy the selected cells.
  • Then, select a cell to link the range of cells. Here we have selected Cell B12.

Range of Cells Linking in Same Excel Worksheet

  • Lastly, use the Paste Link option like Method1 to link the range of cells.

Range of Cells Linking in Same Excel Worksheet

Read More: How to Link Multiple Cells in Excel (4 Methods)


4. Use of Functions to Link Cells in Same Worksheet

Sometimes, we need to apply different functions at the time of linking cells. In this procedure, we will demonstrate the easiest way to use any function while linking cells. Here, we are going to use the SUM Function.

Follow the steps below.

STEPS:

  • Firstly, select the cell where you want to link cells. We have selected Cell B12.

  • Now, type the formula.
=SUM(Functions!C6:C9)

Use of Functions to Link Cells in Same Worksheet

Here, we have used the SUM Function. The ‘Functions’ inside the sum function is the name of the worksheet. You will have to write the name of your worksheet here. We have to use an exclamatory sign (!). Then we have to write the range of cells that we want to sum up.

  • Finally, press Enter and you will see the sum of cells from C6 to C9.

Use of Functions to Link Cells in Same Worksheet


Excel Linking Cells from Different Worksheet

We have discussed the process of linking cells in the same worksheet above. Frequently, we also need to link cells from different cells. Now, you can read this method to learn how you can link cells from different worksheets.

We will utilize the same dataset here. But, our dataset will lack values of the Salary column. We will link these cells from a different worksheet.

Follow the steps to master this procedure.

STEPS:

  • Firstly, select Cell D5.

  • Secondly, enter the formula.
=Functions!D5

Here, Functions is the name of the worksheet from where we want to link cells. And D5 is the cell we need to link. We have to put an exclamation mark (!) between them.

  • Now, press Enter and the cell will be linked.


Tips to Identify Linked Cells in Excel

In this case, to identify linked cells, we will take the help of the formula bar. You can select any cell and look at the formula bar. You will see the formulas below.

  • If linked cells are within the same workbook, you will see.
=Worksheet Name!Reference
  • If linked cells are of the different workbooks, you will see.
=Full Pathname for Worksheet!Reference

Conclusion

All things considered, linking cells are necessary for different reasons to perform effective data analysis. Here, we have discussed 4 methods to link cells in the same worksheet. Furthermore, we have explained how you can link cells from different worksheets. I hope this article will help you to know everything about linking cells. Last of all, if you have any queries or suggestions, feel free to ask in the comment section below.


Further Readings

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer as well as an electrical and electronics engineer. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo