I don't know if this behavior can be adjusted. Say I have a formula in
cell C2 like this: =SUM(A2,B2). when i drag the fill handle to the cell
to the right and choose copy cells from the auto fill options, the
formula changes to: =SUM(B2,C2) returning a different result. It still
changes also when the fill handle is dragged downwards.
How can I drag the fill handle and copy cells with auto fill and still
get the same formula in the adjacent cell or new cell.
TIA

--
two things i learnt from life:
the hardest things are the simplest of all; they just take time
the simple things are not hard at all
So I just try to KISS it.
http://emekadavid-solvingit.blogspot.com

See help on Absolute and Relative cell referencing.

In your sample post...............=SUM($A$2,$B$2) would preserve the references.

A2 is relative

$A2 is absolute column, relative row

A$2 is relative column, absolute row

$A$2 is absolute row and column.

BTW.............=A2+B2 is same as =SUM(A2,B2)


Gord Dibben MS Excel MVP

On Mon, 27 Sep 2010 14:51:46 +0100, transkawa <(E-Mail Removed)> wrote:

>
>I don't know if this behavior can be adjusted. Say I have a formula in
>cell C2 like this: =SUM(A2,B2). when i drag the fill handle to the cell
>to the right and choose copy cells from the auto fill options, the
>formula changes to: =SUM(B2,C2) returning a different result. It still
>changes also when the fill handle is dragged downwards.
>How can I drag the fill handle and copy cells with auto fill and still
>get the same formula in the adjacent cell or new cell.
>TIA

What you need to do is enter the formula as an absolute reference. You can read a short tutorial explaining how to use Absolute References in Excel here:

http://www.myonlinetraininghub.com/e...e-missing-link

You can also get free Microsoft Office Online Training, with over 10 hours of video tutorials on Excel, Word & Outlook.

Submitted via EggHeadCafe - Software Developer Portal of Choice
Auto-Generate Code for LINQ to SQL Repository Pattern using T4
http://www.eggheadcafe.com/tutorials...-using-t4.aspx

In article <(E-Mail Removed)>,
(E-Mail Removed) says...
>
> See help on Absolute and Relative cell referencing.
>
> In your sample post...............=SUM($A$2,$B$2) would preserve the references.
>
> A2 is relative
>
> $A2 is absolute column, relative row
>
> A$2 is relative column, absolute row
>
> $A$2 is absolute row and column.
>
> BTW.............=A2+B2 is same as =SUM(A2,B2)
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 27 Sep 2010 14:51:46 +0100, transkawa <(E-Mail Removed)> wrote:
>
> >
> >I don't know if this behavior can be adjusted. Say I have a formula in
> >cell C2 like this: =SUM(A2,B2). when i drag the fill handle to the cell
> >to the right and choose copy cells from the auto fill options, the
> >formula changes to: =SUM(B2,C2) returning a different result. It still
> >changes also when the fill handle is dragged downwards.
> >How can I drag the fill handle and copy cells with auto fill and still
> >get the same formula in the adjacent cell or new cell.
> >TIA

thanks. I think it didn't occur to me to insert the $ for both the
column and row references. thanks for the reminder.
nnaemeka david

--
Never question, keep asking
234 702 866 8957
http://emekadavid-solvingit.blogspot.com