neadods: (Default)
neadods ([personal profile] neadods) wrote2004-06-10 08:32 am

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!

[identity profile] theo-knight.livejournal.com 2004-06-10 05:45 am (UTC)(link)
Nea:

Call me and I'll walk you through it.

Dave