How do I create a formula repeated on the adjacentt columns?
ToolsOptionsCalculation.
Make sure you are set for "Automatic".
Also be sure you don't have absolute references in the first cell.
C3 should have =A3*B3 which will increment to =A4*B4 as you copy down.
You may have =$A$3*$B$3 which fixes the references to just those two cells.
Remove the $ signs from C3 formula and try again with the copy down.
Don't forget the = sign
Gord Dibben MS Excel MVP
On Mon, 1 Oct 2007 14:34:00 -0700, Excelless
wrote:
But how do I create the formula itself? This just overwrote all the previous
data cells with the top cell's value - thx.
"Excelless" wrote:
I am trying to make the same operation for each column - the only difference
is in the rows, e.g.
C3=A3*B*
C4=A4*B4, etc.
I don't want to have to re-enter a similar formula for each added row.
Thanks.
|