Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to add, say A3 + B3 and have the sum of those two cells in C3, but apply this principle to the whole columns, so I will also get sum of A4 + B4 in C4 etc. all the way down to the sum of A432 + B432 in C432.

I am sure it's quite simple if you know how.

share|improve this question

In cell C3 type the formula


select C3. Right click » Copy. Select C432. To select the entire range C3–C432, press CtrlShift. Paste via CtrlV.

There are a dozen ways to do the same. As this is the most basic of tasks, perhaps a tutorial would be useful.

share|improve this answer
Works a treat!Thanks for your help. I guess a tutorial is the way to go for this user...... – Robin Jan 31 '13 at 22:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.