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.
How to Link Two Excel Sheets: 3 Easy Ways
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.
='Source Sheet'!B4
- Press Enter.
You will have the Source Sheet along with its data linked in the Destination Sheet in Excel.
Read More: How to Link Sheets in Excel with a Formula
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.
Read More:Â How to Link Excel Data Across Multiple Sheets
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,
=Source!B4
- 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,
=’Person Names’!B4Read More: How to Link Data in Excel from One Sheet to Another
Download Workbook
You can download the free practice Excel workbook from here.
Conclusion
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.
