How to Reference a Cell From Another Sheet in Microsoft Excel

Quick summary

To reference a cell from another sheet in Microsoft Excel, you type a formula using the sheet name followed by an exclamation mark and the cell address (e.g., SheetName!A1). This lets you link data across multiple worksheets without copying values manually.

Steps

1. In your Excel sheet, select the cell where you want the reference to appear, then type an equal sign (=).
2. Enter the name of the sheet that contains the cell you want to reference.
3. Type an exclamation mark (!) immediately after the sheet name.
4. Type the cell reference (e.g., A1) you want to pull data from.
5. Click anywhere on the worksheet to run the formula and apply the changes.
6. The value from the referenced cell in the other sheet will now be displayed in your current cell.