Microsoft Excel has a feature to link one sheet with another. In this article, we will show you how to link two excel sheets in 3 easy ways.
You can download the free practice Excel workbook from here.
3 Easy Ways to Link Two Sheets in Excel
In this section, you will learn how to link two excel worksheets with formula, with the Paste Link option and manually in Excel.
1. Formula to Link Two Worksheets in Excel
As shown in the picture below, we have two excel sheets named Destination Sheet and Source Sheet.
We have data in the Source Sheet which we will retrieve in the Destination Sheet by linking them.
- In the Destination Sheet, pick a cell (we picked Cell B4) and in that cell, first write an equal sign (=).
- Then click on the Source Sheet and the data (Marvel Movies in Cell B4) that you want to retrieve in the Destination Sheet. You will see the whole formula by this process in the formula bar.
- Press Enter.
You will have the Source Sheet along with its data linked in the Destination Sheet in Excel.
- How to Link Data from One Spreadsheet to Another in Excel
- Link Excel Workbooks for Automatic Update (5 Methods)
- How to reference cell in another Excel sheet based on cell value!
- Reference from Another Excel Workbook without Opening (5 Examples)
- How to Link Multiple Cells from Another Worksheet in Excel (5 Easy Ways)
2. Copy-Paste Option to Link Two Excel Sheets
Here we will link two sheets with Excel’s Copy-Paste option.
Notice below, we have two excel sheets named Destination WS and Source WS.
In the Source WS, we have some data (DC Movies in Cell B4).
- First, we will copy the data from the Source WS worksheet.
- Then go back to the Destination WS sheet and click on the cell where we want to place the copied data.
- In that cell (Cell B4 in our case), right-click on the mouse and select the Paste Link option.
This process will copy the data from the Source WS worksheet to the Destination WS worksheet through a link.
If you click on the copied cell in the Destination WS, you will see the whole formula behind Cell B4 in the formula bar.
3. Manually Link Two Excel Worksheets
You can also manually write down the whole formula to link one sheet with another. Just follow this process:
equal sign (=) -> sheet name -> exclamatory mark (!) -> cell reference
Even if you don’t enter the worksheet name in capital letter, Excel will add it to the formula.
See the following picture where we have two excel worksheets named Destination and Source.
Source worksheet has some data which will be copied through a link in the Destination worksheet by manually writing a formula.
- In the Destination sheet, pick a cell (in our case, it was Cell B4).
- Then write the formula as,
- Press Enter.
You will get the data from the Source worksheet in the Destination worksheet.
In linking formulas, if you add spaces and special characters, they must be wrapped in single quotes. For example,
This article showed you how to link two sheets in Excel. I hope this article has been very beneficial to you. Feel free to ask if you have any questions regarding the topic.
- Transfer Specific Data from One Worksheet to Another for Reports
- How to Link Sheets to a Master Sheet in Excel (5 Ways)
- Link Files in Excel (5 Different Approaches)
- How to Link Excel Workbooks (4 Effective Methods)
- Link Cell to Another Sheet in Excel (7 Methods)
- How to Link Sheets in Excel with a Formula (4 Methods)