Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .