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