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?

Use absolute reference

=A1+K$1

If this post helps click Yes
---------------
Jacob Skaria


"The mighty john" wrote:

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?

type $K$1 instead of K1 only.

"The mighty john" wrote:

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?

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
---------------
Jacob Skaria


"The mighty john" wrote:

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?