- A cell reference, also known as a cell address, is a formula that identifies a cell on a worksheet by combining a column letter with a row number.
- A1 denotes the cell at the junction of column A and row 1; B2 denotes the second cell in column B; and so on.
- Cell references are used in formulas to help Excel discover the values that the formula should calculate.
- To copy the value of A1 to another cell, for example, use the following formula:
- =A1
- You can use this formula to sum the numbers in cells A1 and A2:
- =A1+A2
Read More: What does the function “and” in excel do?
