Read More: How to Link Cells in Same Excel Worksheet (4 Quick Ways) Now, any modification in the source worksheet will reflect in the destination worksheet. Now, right-click on Cell C4 and click on Paste Link like we showed (You can also find it to Paste Special option).Īs you can see, our destination cell is linked to the source sheet.First, copy the total sales from the Sales sheet.Now, from these two sheets, we will create a link between Cell C10 of Sales and Cell C4 of Link Sales sheet.

Our source worksheet is Sales and our destination sheet is Link Sales. Here, you have to enter also the cell reference along with the worksheet name. Now, linking cells between two different worksheets is pretty simple. Read more: How to Link Two Cells in Excel (6 Methods)Ģ. So, clearly, we made a link between these cells in the Excel worksheet. Also, you can see that our linked cell was also modified. Here, you can see we made a change in the Transportation bill. To verify, let’s make any change in the source dataset: Now, to create a link between these cells, simply type the cell reference of the total bills:Īfter pressing Enter button, you will see the following:Īs you can see, both cells show the same values. On the right-hand side, we created another field to link the cell with the total bills. We have a cell that indicates the total bills. You have to type the cell reference in the destination cell that refers to another cell. Now, creating a link between two cells is pretty easy. It will definitely develop your Excel knowledge. We recommend you learn and apply all these methods to your worksheet. In the following sections, we will provide you with seven ways to create a link between cells in Excel. Most of the time, we are going to use option 3. Using the Paste Link command from Paste Special.

How to link cells in excel for mac