||Refer to values in
||the cell in column A and row 10
||cell A10 and cell A20
||the range of cells in column A and rows 10 through 20
||the range of cells in row 15 and columns B through E
||the range of cells in columns A through E and rows 10 through 20
Cell references can indicate particular cells or cell ranges in columns and rows.
Cell references identify individual cells in a worksheet. They tell Excel where to look for values to use in a formula. In this lesson you'll see why Excel can automatically update the results of formulas that use cell references, and how cell references work when you copy formulas. In the practice session at the end of the lesson, you'll have a chance to try out what you've learned.
When you've finished reading this page, click the Next button to continue the lesson on your own.
By default, Excel uses a reference style called A1, which refers to columns with letters and to rows with numbers. The letters and numbers are called row and column headings. The table shows how to refer to cells by using the column letter followed by the row number.
What happens if the value in a cell changes after a total is calculated? Click Next to find out.