Table of Contents### Using Functions Across Worksheets

Entire Site

- Click in the cell in which you want the result of the formula to appear (this is called the resultant cell).
- Click the AutoSum button on the Standard toolbar. Excel selects the logical cells to sum.
- In this example, we are going to add the sum of this operation to last year's data in another worksheet (2003), so type a + outside the right bracket.
- Click the tab of the worksheet that contains the cell you want to reference in the calculation.

## TIP

Worksheet name references

Instead of switching back and forth between worksheets, you can reference the worksheet name in your calculations. The location of a cell in a particular worksheet is the cell row and column location in addition to the sheet name—for example, Sheet1!A1.

- Click the cell that you want to use in your calculation; it appears next to the worksheet name in the Formula bar.
- Press the Enter key. Excel performs the calculation and returns you to the original worksheet.
- Click the resultant cell to make it the active cell. Notice that the function is displayed in the Formula bar.