Stupid Excel Question
Jun. 10th, 2004 08:32 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
neadodsI know there's a way to copy calculations... but I don't know what it is.
Basically, I have a spreadsheet. Col. A + Col. B = Col. C Col. D + Col. E = Col. F
There is a way to set the sum =SUM(A1+B1) at the top of column C, and then to select the rest of column C and hit a couple of keys so that it will fill in the rest of the sums so that the next row will have =SUM(A2+B2) and then A3+B3 all the way down.
But I can't for the life of me remember those keystrokes. HEEEEELLLLP! Handcoding those buggers will take an unnecessary forever!
Basically, I have a spreadsheet. Col. A + Col. B = Col. C Col. D + Col. E = Col. F
There is a way to set the sum =SUM(A1+B1) at the top of column C, and then to select the rest of column C and hit a couple of keys so that it will fill in the rest of the sums so that the next row will have =SUM(A2+B2) and then A3+B3 all the way down.
But I can't for the life of me remember those keystrokes. HEEEEELLLLP! Handcoding those buggers will take an unnecessary forever!
