There is
another way to manage copying formulas so that they point to the
right data. An
Absolute Reference is defined an 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.
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.3. Apply cell references in
formulas: Absolute Cell References
|
|
| |
