Absolute References

When you need to work with one particular cell you need an Absolute Reference.


Try it: Create an Absolute Reference

Select Cell D7.

The Formula bar shows =D6+B3.

Go to the Formula Bar and click on B3.

Click the F4 function key on the top row of the keyboard.


What Do You See? The cell reference becomes $B$3. This means "go to B3 only, and no place else," to get the data.

Try This, Too: AutoFill the Formula

Select Cell D7 and AutoFill the revised equation to the rest of the rows.


A Mixed Reference uses Absolute and Relative cell references.

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.3. Apply cell references in formulas: Use Absolute and Relative cell references