Create Basic Formulas Modifying a Worksheet

Create a cell reference to another worksheet

1.    Click the cell in which you want to enter the formula.

2.    In the formula bar , type = (equal sign) and the formula you want to use.

3.    Click the tab for the worksheet to be referenced.

4.    Select the cell or range of cells to be referenced.