Trying to understand reference cells

  • Thread starter Thread starter DavidJ726
  • Start date Start date
D

DavidJ726

Lets say cell A1 is the fixed value I want to reference .

B2, C2, D2, & E2 are all different factors (costs & quantities) in an
equation, and F2 which also references A1 is the final result. I'll
develop several scenerios in new rows, 3, 4, 5, 6, 7 & 8.

When I click, hold & drag F2 down to F8, the reference to A1 changes. How
do I keep A1 referenced as I drag? I'm searching the KB as well as this
group, but I'm not sure how phrase my question...

Thanks,

David...
 
Hi David

click on A1 in your formula and press the F4 key, this will turn the cell
reference into $A$1 ... and then it won't change as you drag it ... there
are four states in total
A1 - both relative
$A$1 - both absolute
$A1 - column absolute, row relative
A$1 - column relative, row absolute

you can either press the F4 key to cycle through the states or type the $
yourself.

Regards
JulieD
 
One way:

Make A1 an absolute reference by putting $ in front of the row and
column identifiers:

$A$1

See "About cell and range references" in Excel Help.
 
Thanks all,

I was searching on locked cells and reference cells, but didn't quite find
what I was looking for. Absolue reference is exactly what I need!

David...
 
Back
Top