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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it