Referring to other sheets

In this lesson

1. 1. Use a cell from another sheet

   A formula can use a cell on another sheet.

   Write the sheet name, then !, then the address. Jan!B2 means cell B2 on the Jan sheet.

2. 2. Point and click

   You can also click instead of typing the address.

   Type =, click the sheet tab, click the cell, then press Enter.

3. 3. Sheet names with spaces

   If a sheet name has a space, put it inside single quotes.

   Excel adds the quotes for you when you click.

4. 4. Bring in the costs

   The costs are in B3 on each month sheet.

5. 5. Try it yourself

   Finish the costs column.

Part of Excel Essentials. Short lessons with practice in a real spreadsheet, checked as you go.