How to Link Two Sheets in Excel (3 Ways)

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.


Download Workbook

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.

two sheets to link in excel with formula

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

Formula to Link Two Work sheets in Excel

  • Press Enter.

Formula to Link Two Worksheets in Excel

You will have the Source Sheet along with its data linked in the Destination Sheet in Excel.

Read more: How to Link Excel Sheets to Another Sheet (5 Ways)


Similar Readings


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.

two sheets to link in excel with paste link

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.

Paste Link Option to Link Two Excel Sheets

This process will copy the data from the Source WS worksheet to the Destination WS worksheet through a link.

Formula from Paste Link Option to Link Two Excel Sheets

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 Reference Worksheet Name in Formula in Excel (3 Easy Ways)


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.

two sheets to link in excel manually

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.

Manually Link Two Excel Work sheets

In linking formulas, if you add spaces and special characters, they must be wrapped in single quotes. For example,

=’Person Names’!B4

Read More: How to Link Data in Excel from One Sheet to Another (4 Ways)


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.


Further Readings

Sanjida Ahmed

Sanjida Ahmed

Hello World! This is Sanjida, an Engineer who is passionate about researching real-world problems and inventing solutions that haven’t been discovered yet. Here, I try to deliver the results with explanations of Excel-related problems, where most of my interpretations will be provided to you in the form of Visual Basic for Applications (VBA) programming language. Being a programmer and a constant solution seeker, made me interested in assisting the world with top-notch innovations and evaluations of data analysis.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo