How Do I Reference a Cell in Another Worksheet in Excel?

Written by gregory hamel
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel is a popular spreadsheet program capable of storing data and performing calculations. One of the most useful features of Excel is the ability to enter formulas into the program and reference existing cells to input data into the formula. Referencing a cell within your current worksheet can be done simply by clicking on the cell. But to reference a cell in a different worksheet, find the appropriate cell in the other worksheet and enter a specific word string into the formula.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Click on the cell containing the formula where you need to reference a different worksheet. To start a new formula, press the "=" key.

  2. 2

    Click on the tab for the other worksheet at the bottom of Excel.

  3. 3

    Note the cell number that you want to reference, such as A1, C3 or D5.

  4. 4

    Go back to the worksheet with the formula.

  5. 5

    Type the name of the worksheet you want to reference (it will be labelled on the tab) followed by "!" and then type the name of the cell you noted earlier. For example, if the worksheet you want to reference is called "AccountData" and you want to reference cell A4 on that sheet, you would type AccountData!A4.

  1. 1

    Follow the first two steps of section 1.

  2. 2

    Locate the cell you want to reference and left click on it.

  3. 3

    Go back to the original worksheet. Excel will have automatically created a reference to the appropriate cell in your formula. (The reference will appear in the worksheetname!cellname form described in section 1.)

Tips and warnings

  • A single formula can contain references to many different worksheets.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.