dragging formulas acros adjacent cells

[transkawa]

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

 

[Gord Dibben]

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

 

[Mynda Treacy]

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/excel-2007-absolute-references-–-the-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/tutorial...-linq-to-sql-repository-pattern-using-t4.aspx

 

[transkawa]

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

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