The formula simply now becomes:

=A1*B1

Follow any one of the numerous procedures in the above posts to copy it down
Column C.

As far as moving and sorting:
You might try copying, and then use "Paste Special" - "Values",
so that only the data is duplicated in those other locations.

That way you could sort however you wished.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Andrea Gates" wrote in message
...

Actually this is what I am after:

Column A (qty) Column B (unit Price) Column C (total price)

21 7
147
26 7
182
28 8
224
33 8
264
77 10 770

Colume A and B are known. Column C is variable.
Is there anyway to insert one simple same formula into all the cells in
column C. Also, how to insert one formula into all the cells in column C?
Can we avoid cell specific, such as using A1, becuase the cell name will
change after sorted and moved into both different column and row of
department master account?

Thank you for you'all