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:
Other People Are Reading
Click on the cell containing the formula where you need to reference a different worksheet. To start a new formula, press the "=" key.
Click on the tab for the other worksheet at the bottom of Excel.
Note the cell number that you want to reference, such as A1, C3 or D5.
Go back to the worksheet with the formula.
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.
Follow the first two steps of section 1.
Locate the cell you want to reference and left click on it.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for