Page 9 of 24PREVNEXT

Get to know Excel 2007: Enter formulas

Cell references Refer to values in
A10 the cell in column A and row 10
A10,A20 cell A10 and cell A20
A10:A20 the range of cells in column A and rows 10 through 20
B15:E15 the range of cells in row 15 and columns B through E
A10:E20 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.

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.

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.

What happens if the value in a cell changes after a total is calculated? Click Next to find out.

Page 9 of 24PREVNEXT