References to Other Worksheets in Excel

Question

How do you reference other worksheets in Excel?

Answer

You can refer to cells in other worksheets within the same workbook just as easily as you refer to cells in the same worksheet. For example, to enter a reference to cell A2 in Sheet2 into cell A1 in Sheet1, do this: 

1. Select cell A1 in Sheet1, and type an equal sign. 
2. Click the Sheet2 tab. 
3. Click cell A2, and then press Enter. 

After you press Enter, Sheet1 is now active. Select cell A1, and you will see that it contains the formula =Sheet2!A2. 
The exclamation point separates the worksheet portion of the reference from the cell portion. 

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3

If you need further assistance, please click the CTL Support Request button on this page