Fixing some values on Fill

T

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF functions 2
How to transpose a list of reference cells without changing the li 2
Combining formulas, "and" & "or" to verify content of multiple cel 15
How to set cell value to emptry if three other columns are empty too 1
Force input & colour cells 4
Naming non-contigent cells with vba 5
Lookup reference help 3
Deletion Of Cells 1

Top