subtract column E to column D in every row

[Guest]

does anyone know how to subract two columns for each row?
D E F
1 3 4 1
2 2 3

instead of me subracting column D from E for every row, is there a formula I
can use to get the diffence to enter in column F? I have about 1000 rows to
do, and it's just taking so long.

thanks

 

[Pete]

In cell F1 enter the formula:

=E1 - D1

Then select the cell again and double-click the "fill handle" - the
small black square in the bottom right corner. This will copy the
formula down automatically for as many rows as you have data in column
E.

Hope this helps.

Pete

 

[Philip Reece-Heal]

In F1 type =D1-E1. That will give you the answer in F1.
Now select F1 and select Copy from the Edit menu. Now highlight all those
cells in column F that you are interested in (select F2 and then hold down
shift key and click in the last cell you want in column F) then select Paste
from the Edit menu

Best of luck
Philip

 

[Guest]

Another way

....select your cells in column F that you want your formula in, next type
your formula in the active cell hold down the Ctrl key and hit enter.

HTH
Jean-Guy

 

[Guest]

i tried doing it, and it didn't subract the other rows...just gave me this on
F1
=F2:F908=E1-D1

 

[Pete]

You should have highlighted F1 to F908, then typed

=E1 - D1

then held down CTRL while pressing ENTER to this method to work.
However, there were two other methods you were given above, so
hopefully one of those has been sucessful for you.

Pete