Preserving formulas when using sort function

[Guest]

Hi

If I have a two columns of data say, A and B and the are added together in
rows in Column C eg

A1 + B1 = C1
A2 + B2 = C2 etc

If I then move the contents of cell A1 and put it in say A23 the value of C1
does not change because the C1 become A23 + B1.

However, if I sort Column A then the value of C1 changes and the formula
appears to be wrong because it now takes the new value of cell A1

How can I make sure that when the sort takes place that wherever the value
in A1 ends up it is still added to B1 to create a value in C1?

Any help appreciated

 

[David McRitchie]

Hi Andy,
Why aren't you moving the entire row 1

Select Row 1
Hold Shift, the drag the upper or lower boundary of the row
between the rows you want to insert between.

More information on mouse operations:
http://www.mvps.org/dmcritchie/excel/fillhand.htm#cursor

Often you have formulas that refer to a cell in the previous row, you would
want to rewrite such formulas to use OFFSET.
http://www.mvps.org/dmcritchie/excel/insrtrow.htm#offset

 

[duane]

If you use absolute references (ie $a$1) then the sort command will not
change the formulas