Absolute References

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

 

8. 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.