How to Link Worksheet Data in Microsoft Excel

Quick summary

Linking worksheet data in Microsoft Excel lets you reference cell ranges across multiple sheets using a simple formula, keeping your data synchronized without manual copying. This method uses an equals sign to create a live reference between a source sheet and a destination worksheet.

Steps

1. On your blank Microsoft Excel worksheet, select a cell and type an equals (=) sign.
2. Navigate to the bottom of the workbook and click the sheet that contains the data you want to link.
3. Select all the data in the source sheet that you want to link to your blank worksheet.
4. Once done, navigate back to the blank destination worksheet.
5. Review the cell range in the formula bar, then press the Enter or Return key to run the formula.
6. The data between the selected Excel worksheets will now be linked instantly.