Trying to understand reference cells

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

JulieD

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
 
J

JE McGimpsey

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

DavidJ726

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