Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 1 down vote accepted

Edit:

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
1  
@nerdwaller Thats it thanks! –  Nicholas Dec 10 '12 at 21:08

Your Answer

 
discard

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.