Copying a formula

[JohnB]

How would I do this?
I want C1 to contain the result of B1-A1
And then I want C2 to contain the result of B2-A2. and so on.... I want the
resulting difference to be in column C, for each row. How can I copy the
formula from C1 to each cell below it, with the formula in each subsequent
cell referring to the cells in that row, not row1?



A B C

 

[Tyro]

Simply put the formula in C1: =B1-A1 and press enter. Then select C1, put
your cursor on the lower right hand corner of C1 where the black box (the
fill handle) is, your cursor will change to a black cross, click on that
and drag your formula down column C as far as you want. Excel will adjust
the addresses in the formula
automatically

Tyro.

 

[JohnB]

Ok, now I feel stupid.
I had tried that. But it didn't work. And I just now realized that it
didn't work because I had a heading in line 1, and my data didn't start
until line 4!

Thanks.

 

[Gord Dibben]

Just grab the fill handle of C1 by left-click and drag/copy down column C.

The cell refs will increment as you go.

If the results shown are the same, perhaps go to Tools>Options>Caculation and
checkmark "Automatic"


Gord Dibben MS Excel MVP