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.