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'm new to excel so this might be a simple question. I have around 100 rows with 7 columns. Out of those, 4 column needs to have the value computed by 3rd and 2nd columns' value of the same row.

I know that this can be done using =C1*B1 and then copy paste this value to the next column. But I don't this is the easiest way. So please help me out with this and thanks in advance.

share|improve this question

1 Answer 1

Forgive me if I did not understand you question very well but try to convert your formula to this - $C1*$B1 and expand the formula to the needed columns and rows.

For copying the formula to other cells - highlight the last row and grab bottom corner to drag and extend to the next row or column.

Please refer to this tutorial for more information - http://www.cpearson.com/excel/relative.aspx

share|improve this answer
    
Thanks for your answer. I want to avoid doing this drag and drop. I want to create an expression to automatically add these consecutive cell values –  Abilash Jan 28 '13 at 11:39
    
Is there any way to do this? –  Abilash Jan 28 '13 at 11:41
    
I want to set this expression for the entire column, once –  Abilash Jan 28 '13 at 11:43
    
I think this will help you - answers.microsoft.com/en-us/office/forum/office_2007-excel/… –  K-man Jan 28 '13 at 12:24

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.