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'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

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 -

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 -… – kazandzhiro Jan 28 '13 at 12:24

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.