How to Reference a Cell From Another Sheet in Microsoft Excel

Updated on:

April 6, 2026

By:

Madhav Bhandari

Use this interactive demo to learn how to reference a cell from another sheet in Microsoft Excel.

‍

It is very easy to reference a cell from another sheet in Microsoft Excel. Here’s a short guide on how to do it:

‍

Inside your Microsoft Excel sheet, select the cell you wish to use and then type an 'Equal' sign (=).
After that, enter the name of the sheet that contains the cell you wish to use as a reference.
Type an 'Exclamation' mark (!) next to the sheet name.
Lastly, type the cell reference' you wish to use.
Tap anywhere around your worksheet to run the formula and apply the changes.
After completing these steps, the value of the selected cell reference from another sheet will be copied and displayed accordingly.

📌 Why this matters

Cross-sheet cell references let you build dynamic connections between different parts of your workbook, so when source data updates, all dependent calculations automatically refresh. This becomes powerful when you're managing multi-tab financial models, departmental budgets, or project tracking sheets.

Instead of manually copying values and risking outdated information, you create a live data pipeline. Your summary dashboard can pull real-time figures from individual team sheets, and changing a single number instantly cascades through every connected formula across your entire workbook.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel