How to create a link between two worksheets in Excel

In this short beginners tutorial let us see the steps for creating a simple link between two worksheets in Excel 2016, 2013 and 2010. In Excel, two worksheets can be linked using the paste options.

1. From Sheet1, Copy the cell value which needs to be linked with the other Sheet. This can be done by right clicking the cell and selecting copy from the context menu or by pressing Ctrl + C.

Right click cell in Excel 2013 and Excel 2010

2. Navigate to Sheet2 and select the cell which needs to be linked. Right click and select Paste link sub menu from Paste Options.

Select Paste link from Context menu in Excel 2013 and Excel 2010

Now any changes to the cell value in Sheet 1 will appear in the cell in Sheet2.

Also See: Display empty value instead of zero in Microsoft Excel

In Category: Excel 2007, Excel 2010, Excel 2013, Excel 2016, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 9 Comments
  • Marsha January 7, 2012, 12:03 am

    Whatever happened to just using and = sign to link documents. I have different columns of numbers I need to sum in a different spreadsheet. Can I still use the old method of using plus signs between the links?

  • Cindy January 10, 2012, 12:38 am

    I wish I knew that answer!!!! It is the same one I have been trying to find out for weeks!!!!

  • Joe February 20, 2012, 10:58 am

    Yes you can still use = sum in multiple sheets Example: =sum(sheet1!B10+sheet2!B10+sheet1!C10)
    Or make sheet 3 active( or any sheet you wish to have the sum in) then type =sum(click the cell in the sheet you desire( this will look like this—— ‘sheet2’!B4 ———–
    then click the + sign click the next cell in a different sheet and close the parenthesis.

    This will not work if you have linked full multiple pages

  • ahmed April 11, 2012, 3:00 pm

    thanx alot

  • heath Howes January 9, 2013, 1:03 am

    Is it possible to save 1 excel file (Home File) on multiple networked workstations and have any changes made to the file at these workstations automatically update the original file?

  • Alana January 27, 2013, 8:39 am

    This is the type of function I need, but when I “insert row” in the source sheet, it doesn’t do the same in the target sheet. Does that make sense? Any feedback on how to do a “link” where that change will automatically reciprocate into the target?

  • January 30, 2013, 1:29 pm

    I have a dropdown on sheet 1 with ( Ready, Hold on ) but the question is.. if I click on Ready than must he be linked to Sheet 2.. Do anyone know what I mean?

  • Dan February 7, 2013, 11:31 pm

    In reply to Heath Howes, the easiest way is to open the file on the computers you want to have access to the Excel file, then right-click and select “Send to Desktop.” Be aware though that any changes will overwrite the original (obviously), and having 2 or more open at the same time might not allow the file to be saved. Also people might be overwriting information others have entered, might not be able to see any changes others are doing, or possibly worse such as accidentally delete information and save not realizing it.
    If you do this, I would back-up the file at MINIMUM daily.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.