0
0
Excelspreadsheet~10 mins

Referencing other worksheets in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sheet1 has numbers in cells A1 to A3. Sheet2 has numbers in cells B1 to B3.

CellValue
Sheet1!A110
Sheet1!A220
Sheet1!A330
Sheet2!B15
Sheet2!B215
Sheet2!B325
Formula Trace
=Sheet1!A1 + Sheet2!B2
Step 1: Sheet1!A1
Step 2: Sheet2!B2
Step 3: 10 + 15
Cell Reference Map
Sheet1       Sheet2
+-----+      +-----+
| A1  |      | B1  |
| 10  |      | 5   |
+-----+      +-----+
| A2  |      | B2  |
| 20  |      | 15  | <-- referenced
+-----+      +-----+
| A3  |      | B3  |
| 30  |      | 25  |
+-----+      +-----+
The formula references Sheet1 cell A1 and Sheet2 cell B2.
Result
Sheet3
+-----+
| C1  |
| 25  | <-- result of =Sheet1!A1 + Sheet2!B2
+-----+
The formula result 25 is shown in cell C1 of Sheet3 (or any sheet where formula is entered).
Sheet Trace Quiz - 3 Questions
Test your understanding
What value does Sheet1!A1 contribute to the formula?
A20
B10
C15
D25
Key Result
To reference another worksheet, use SheetName!CellReference in the formula.