Use cell references
Cell references identify individual cells or cell ranges in columns and rows.
Cell references tell Excel where to look for values to use in a formula.
Excel uses a reference style called A1, which refers to columns with letters and to rows with numbers. The numbers and letters are called row and column headings.
This lesson shows how Excel can automatically update the results of formulas that use cell references, and how cell references work when you copy formulas.
the range of cells in columns A through E and rows 10 through 20
Refer to values in
the range of cells in column A and rows 10 through 20
the range of cells in row 15 and columns B through E
cell A10 and cell A20
the cell in column A and row 10