Understand and use cell references

One of the key things you’ll calculate in Excel are values in cells, the boxes you see in the grid of an Excel worksheet. Each cell is identified by its reference—the column letter and row number that intersect at the cell's location. For example, a cell in column D and row 5 is cell D5. When you use cell references in a formula, Excel calculates the answer automatically using the numbers in the referenced cells.

Cell references

Watch this video to learn the basics. When you use cell references in a formula, Excel calculates the answer using the numbers in the referenced cells. When you change the value in a cell, the formula calculates the new result automatically. (1:44)

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Copying formulas

We just saw how to create a formula that adds two cells. Now let’s copy the formula down the column so it adds the other pairs of cells. (3:13)

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

A brief reminder of the key points in this course summary.

More courses available at Microsoft Office Training.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×