# How to Link Two Sheets in Excel – 3 Methods

### Method 1 –Â  Using a Formula to Link Two Worksheets in Excel

There are two Excel sheets:Â  Destination Sheet and Source Sheet.

There is data in the Source Sheet that will be retrieved in the Destination Sheet by linking the two sheets.

• In the Destination Sheet, select a cell (here,Â B4) and enter an equal sign (=).

• Click the Source Sheet and the data (Marvel Movies in B4) that you want to retrieve in the Destination Sheet. You will see the whole formula in the formula bar.
`='Source Sheet'!B4`

• Press Enter.

You will have the Source Sheet linked to the Destination Sheet .

### Method 2 – Using the Copy-Paste Option to Link Two Excel Sheets

In the Source WS, there is data (DC Movies in B4).

• Copy the data in Source WS.

• Go back to Destination WS and click the cell in which you want to place the copied data.
• In that cell (B4, here), right-click and select Paste Link.

Data will be copied from Source WS into the Destination WS through a link.

If you click the copied cell in Destination WS, you will see the formulaÂ in the formula bar.

### Method 3 –Â  Linking Two Excel Worksheets Manually

Create a formula to link one sheet to another:

equal sign (=) -> sheet name -> exclamatory mark (!) -> cell reference

The image showcases two worksheets: Destination and Source.

Source contains data that will be copied through a link into Destination by entering a formula manually.

• In Destination, select a cell (here, it B4).
• Enter the formula:
`=Source!B4`

• Press Enter.

Data from Source is copied into Destination.

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

`=â€™Person Namesâ€™!B4`

## Related Articles

<< Go Back To Excel Link Sheets | Linking in ExcelÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sanjida Ahmed

Sanjida Ahmed, who graduated from Daffodil International University with a degree in Software Engineering, has worked with SOFTEKO since 2021. She has written over 100 articles on Excel & VBA and, since 2022, has worked as the Project Manager of the Excel Extension Development Project in the Software Development Department. Since starting this software development, she has established an outstanding workflow encompassing a full SDLC. She always tries to create a bridge between her skills and interests in... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF