How to link sheets in excel workbook

1

Open a Microsoft Excel workbook. The Excel icon looks like a green-and-white "X" icon.

2

Click your destination sheet from the sheet tabs. You will see a list of all your worksheets at the bottom of Excel.

Click on the sheet you want to link to another worksheet.^[2]

Advertisement

3

Click an empty cell in your destination sheet. This will be your destination cell.

When you link it to another sheet, the data in this cell will be automatically synchronized and updated whenever the data in your source cell changes.^[3]

4

Type in the cell. It will start a formula in your destination cell.

5

Click your source sheet from the sheet tabs. Find the sheet where you want to pull data from, and click on the tab to open the worksheet.

6