Hello folks,
So my question is this. Using Excel 2010, is there a way in which once you inserted a row, a particular cell in that row, the formula is automatically filled in rather than coping the row above it or using that cross thing when the mouse button is hold down and then dragging down the formula?
example
column
A B C
YEN rate total (usd)
row 1 10690 0.0082500 =B1*A1
row 2 18304 0.0082500 =B2*A2
row 3 31616 0.0082500 =B3*A3
row 4 total =sum(C1:C3)
now, after a insert a row
A B C
YEN rate total (usd)
row 1 10690 0.0082500 =B1*A1
row 2 18304 0.0082500 =B2*A2
row 3 =B3*A3 - for cell C3, how can I get the formula to automatically to be there without mE copying or dragging the formula from above?
row 4 31616 0.0082500 =B4*A4
row 5 total =sum(C1:C4)
thnks