Create an Absolute
another way to manage copying formulas so that they point to the
Absolute Reference is defined as a specific Row or Column. The
Absolute Reference will NOT update if it is copied to another Row
This: Create an Absolute Reference
cursor in the Formula Bar on B1.
keyboard, click on F4.
You See? The formula in Cell C6 is now: =$B$1, where the dollar
$ sign means that it is Absolute.
This Too: AutoFill the Absolute Reference
click the Autofill handle.
like it worked this time.