Stupid Excel Question
I 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!
no subject
Call me and I'll walk you through it.
Dave