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.
2. Navigate to Sheet2 and select the cell which needs to be linked. Right click and select Paste link sub menu from Paste Options.
Now any changes to the cell value in Sheet 1 will appear in the cell in Sheet2.