Create an Absolute Reference

There is another way to manage copying formulas so that they point to the right data.


An Absolute Reference is defined as a specific Row or Column. The Absolute Reference will NOT update if it is copied to another Row with Autofill.


5. Try This: Create an Absolute Reference

Select Cell C6.

Click your cursor in the Formula Bar on B1.

On your keyboard, click on F4.


What Do You See? The formula in Cell C6 is now: =$B$1, where the dollar $ sign means that it is Absolute.


Try This Too: AutoFill the Absolute Reference

Select Cell C6.

Double click the Autofill handle.


It looks like it worked this time.

Keep going...


Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.1 Apply Cell Ranges and References in Formulas and Functions:  Use References (Relative, Mixed, Absolute)