Add a worksheet to your workbook called Mapping. This worksheet will specify the links between two different worksheets. Put the name of the two worksheets in Mapping!A1 and B1 Put the cell or range addresses to be linked in columns A and B. A static link is an address like B5 or C4:D6. Sep 04, 2017 · typing = and select cell (or type cell address) is the simplest method to link a single cell in the same sheet, but if formula writing is a little foreign to you or if you want to link multiple cells or if the cells you are linking are in differen... Option 1: Using Paste Link 1. In the source worksheet select the required cells. 2. Copy the selected data, e.g. CTRL + C or right-click, Copy. 3. Switch to the dependent worksheet and then select the upper left corner... 4. To paste the link do one of the following: 5. The data will be pasted ... Steps to create hyperlink between different Workbooks : 1. Open Microsoft Excel Book1. 2. At the bottom of the Book1, by default you find three sheets as sheet1, sheet2, sheet3 and an option to add on extra sheets.