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 was wondering how you would make a function for a whole columns by using other columns in the function. So for example column C = A + B. and this would work for the whole column not matter what the row is. Note: I do know how to select a whole column. :)

EDIT: what i am meaning is that for c3 c4 c5 c6 ect all have the function that the a3+b3 = c3 then a4+b4=c4 and so on and so forth

Thanks in advance

share|improve this question
up vote 1 down vote accepted


Sorry about that, I misunderstood.

All you need is to have the function in the first cell, then you "drag" it down and it will fill for you.

In the screenshot, you can see the function bar, me dragging it and the arrow is to the little box to drag with.

enter image description here

share|improve this answer
See my edit sorry – Nicholas Dec 10 '12 at 20:58
@Nicholas - Is that what you meant? – nerdwaller Dec 10 '12 at 21:05
What's it going to be.... – Jacob Jan Tuinstra Dec 10 '12 at 21:08
@nerdwaller Thats it thanks! – Nicholas Dec 10 '12 at 21:08

You must log in to answer this question.

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