Referring to Cells and Ranges in Formulas and Functions
To make your formulas and functions work correctly, you need to refer to the cells and ranges you want. You can create references to cells and ranges in different locations:
- On the same worksheet as the formula
- On a different worksheet than the formula
- In a different workbook than the formula
Referring to a Cell or Range on the Same Worksheet
To refer to a cell on the same worksheet, enter its column lettering and its row number. For example, use
=A10 to refer to cell A10.
You can either type in the reference or click the cell—whichever you find easier. You'll see examples of this shortly.
Similarly, to refer to a range, enter the range's address. For example, use
=A10:A20 to refer to ...