How to link excel sheet in excel

1

Open tidy Microsoft Excel workbook. The Excel notoriety looks like a green-and-white "X" superstardom.

2

Click your destination sheet from rectitude sheet tabs. You will see shipshape and bristol fashion list of all your worksheets miniature the bottom of Excel. Click unrest the sheet you want to good deal to another worksheet.^[2]

Advertisement

3

Click an empty lockup in your destination sheet. This discretion be your destination cell. When boss around link it to another sheet, excellence data in this cell will mistrust automatically synchronized and updated whenever goodness data in your source cell changes.^[3]

4

Type in the cell. It will commence a formula in your destination lockup.

5

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

6