# How to Link Two Sheets in Excel (3 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

### 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,
`=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â€™!B4`

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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

Advanced Excel Exercises with Solutions PDF