Linking in Excel

Dear Doreen

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

It depends how you would like to link worksheets.

If you simply want to link a cell on a worksheet to another cell of another worksheet then you follow these steps. We'll assume the two files are called worksheet 1 (Source sheet) and worksheet 2 (Destination sheet):

1. Click on Worksheet 2 and the Cell WHERE you want the data to be linked to.

2. Press = on the keyboard

3. Click on the Worksheet 1 and the Cell WHERE the Data is coming FROM.

4. You will notice that the same information that is in sheet 2 is in sheet 1.

You can do the same by using the Edit Special command. All you do in this case is simply click on the cells in the Source file (Sheet 1) and choose Copy (Ctrl + C)

Then you click on the cell in the destination sheet (sheet 2).

Then you choose Edit > Paste Special... from the Menu bar.

In the Paste Special dialog box and then click on the Paste Link button.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT