In Microsoft Excel, we need to link cells to perform different operations. Like, when we apply a formula. We can link multiple cells in the same sheets, multiple sheets, and multiple files. In this article, we will discuss how to link multiple sheets in Excel with proper illustration and explanation.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
4 Methods to Link Multiple Cells in Excel
Linking cells in Excel is a little bit tricky process. We’ll show here 4 different methods to link cells in Excel. We will consider the following dataset for this purpose.
1. Connect Two Single Cells of Different Sheets in Excel
We can make a relationship between two single cells in Excel by easy two methods.
1.1 Simple Mouse Click to Link Cell in Same Sheet
In this section, we will use the simple mouse click to link cells in the same sheet.
Step 1:
- At Cell D11, we want to get the name of the employee of salary $1000. Go to Cell D11.
- Put an equal (=) sign, then move the cursor to Cell B5. Cell B5 contains the name of the employee getting a salary of $1000.
Step 2:
- Press the Enter button.
1.2 Use Paste Special Shortcut to Link Cell in Same Sheet
We can use the simple keyboard shortcut to link cells in the same sheet.
Step 1:
- Go to Cell B5 and press Ctrl+C to copy that cell.
Step 2:
- Now, go to Cell D11.
- Press Ctrl+Alt+V to paste.
Step 3:
- Paste Special window will appear. Choose Paste Link from that window.
Now, Cell B5 and Cell D11 are linked together. If we modify Cell B5 that will reflect on Cell D11.
Read More: How to Link Two Cells in Excel (6 Methods)
2. Link Multiple Cells from Different Sheets
In this method, we will show how to link multiple cells of different sheets.
We have two sheets Sheet1 and Sheet2. In Sheet2, we want to link the cells of the Salary column of Sheet1.
Step 1:
- First, go to Cell C5 of Sheet2.
- Put an equal (=) sign.
- Now, click on Sheet1 from the sheet name field.
Step 2:
- Select Range D5:D9 then press Enter.
Now, go to Sheet2.
Now, the cells of the Salary column of Sheet1 and Sheet2 are linked together.
Read More: How to Link Cells in Same Excel Worksheet (4 Quick Ways)
3. Link Cell from Different Sheets as Cell Reference in a Formula
In this example, we will show how to link cells of different sheets using a function in Excel.
We have two sheets Sheet1 and Sheet3. We want to get the total cost in Sheet3 using a SUM function and the salary column of Sheet1.
Step 1:
- Go to Cell D4 of Sheet3.
- Put an equal(=) sign and the SUM function.
- Now, choose Sheet1 from the sheet name bar.
Step 2:
- Select Range D5:D9 and then close the formula putting the right bracket.
Step 3:
- Now, press Enter.
Finally, we get the sum of salary linking the cells of Sheet1 to Sheet3 with the SUM function.
Read More: How to Keep Formatting in Excel When Referencing Cells (2 Methods)
4. Link Cells from Different Excel Workbooks
We want to link cells of different Excel files. There are two Excel files Link Multiple Cells in Excel and Linked Excel File. We will link the 1st file to the 2nd file with function.
Step 1:
- Go to Cell D4 of the Linked Excel File. Put an equal sign and the SUM function.
- Then Choose Range D5:D9 from the Link Multiple Cells in Excel.
Step 2:
- Hit the Enter button to execute.
Now, we link both files based on cells.
Read More: How to Link Multiple Cells from Another Worksheet in Excel (5 Easy Ways)
Conclusion
In this article, we described how to link multiple cells in Excel. We also showed how to link cells of multiple sheets. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.