Fixing some values on Fill

[The mighty john]

How do I keep a particualr value fixed when using fill.

e.g. I want to use fill to produce a set of formulas:

=A1+K1, =A2+K1, =A3+K1..........

But using fill I get:

=A1+K1, = A2+K2, =A3+K3...........

So how do I do it so that K1 is fixed?

 

[Jacob Skaria]

Absolute reference and Relative reference.

$A$1 Both column and row references are fixed. Both column and row will be
changed during a copy/fill operation.

$A1 Only column reference is fixed but row will change

A$1 Only row reference is fixed but the column will change.

If this post helps click Yes