Sheet References

In your current sheet, you can refer to cells in other sheets within your workbook.

To refer to cells in another sheet:

  1. Type the sheet name, followed by an exclamation mark (!). For example, Sheet1!.

  2. Type the cell references as you normally would. For example, Sheet1!B1 refers to cell B1in Sheet1.

Example:

Perhaps your workbook has two sheets, with the names Sheet1 and Sheet2. You want to find the sum of cells B2 to F10 in Sheet2, and insert this sum into cell A1 in Sheet1. To do so:

  1. Go to Sheet1 by clicking the tab at the bottom of the sheet.

  2. In Sheet1, click cell A1.

  3. Type in the formula =SUM(Sheet2!B2:F10).

  4. Press Enter.

  5. The sum of cells B2 to F10 in Sheet2 will be placed in cell A1.

 

See Also:

Naming a Sheet