• 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?