Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

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.