How to Link Worksheets in Excel: 10 Steps

Table of contents:

How to Link Worksheets in Excel: 10 Steps
How to Link Worksheets in Excel: 10 Steps
Anonim

This article explains how to link data in a Microsoft Excel workbook with multiple sheets together. Linking dynamically extracts data from one sheet and relates it to that of another. The update of the destination sheet occurs automatically at each modification of the source sheet.

Steps

Link Sheets in Excel Step 1
Link Sheets in Excel Step 1

Step 1. Open a Microsoft Excel workbook

The Excel icon appears as a white and green "X".

Link Sheets in Excel Step 2
Link Sheets in Excel Step 2

Step 2. Click on the destination sheet by selecting it from the tabs that identify the sheets

At the bottom of the Excel screen you can see the complete list. Click on the sheet you want to link.

Link Sheets in Excel Step 3
Link Sheets in Excel Step 3

Step 3. Click on an empty cell of the destination sheet

It will be your target cell. The data contained in the cell, once linked to that of another sheet, will be automatically synchronized and updated every time a change occurs in the source cell.

Link Sheets in Excel Step 4
Link Sheets in Excel Step 4

Step 4. Type = in the cell

This mark introduces a formula into the target cell.

Link Sheets in Excel Step 5
Link Sheets in Excel Step 5

Step 5. Click on the source sheet by selecting it from the tabs that identify the sheets

Locate the sheet you want to extract data from, then click the tab to open the workbook.

Link Sheets in Excel Step 6
Link Sheets in Excel Step 6

Step 6. Check the formula bar

This displays the target cell value at the top of the Excel screen. When you switch to the source sheet, it should display the name of the active sheet, preceded by an “equal” sign and followed by an exclamation point.

Alternatively, you can manually enter the formula in its bar. It should look like this: =!, where "" stands for the name of the source sheet.

Link Sheets in Excel Step 7
Link Sheets in Excel Step 7

Step 7. Click on a cell of the source sheet

It will be your cell of origin. It can be empty or already contain data. When you link the data, the target cell is automatically updated based on the source cell.

If, for example, you want to extract data from cell D12 of Sheet1, the formula is the following: = Sheet1! D12.

Link Sheets in Excel Step 8
Link Sheets in Excel Step 8

Step 8. Click on the Enter key on your keyboard

This way you apply the formula and return to the target sheet. The target cell is now linked to the source cell and the data is dynamically linked together. When you change the source cell, the destination cell is automatically updated as well.

Link Sheets in Excel Step 9
Link Sheets in Excel Step 9

Step 9. Click on the target cell

The cell is thus highlighted.

Link Sheets in Excel Step 10
Link Sheets in Excel Step 10

Step 10. Click and drag the square icon in the upper right corner of the target cell

The range of the linked cells between the source sheet and the destination sheet is thus extended and the adjacent cells of the source sheet are also linked.

Recommended: