repeating formulas

Originally Posted by jbenn10

I am new to using excel and was wanting to know if I can repeat a formula in several cells such as something simple like A2+B2...if I wanted to do the same thing like A3+B3 , A4+B4 etc. Do I have to put the equation in each cell? Thanks for any help,this is probably "simple" but as I said it's all new to me

Hi,

see http://www.mvps.org/dmcritchie/excel/fillhand.htm or http://www.contextures.com/xlDataEntry01.html

added, the simple explanation is, in C3 put =A3+B3
then click on the fill handle and drag the formula downwards as far as required.

hth
---

Originally Posted by jbenn10

thanks so much for the quick reply...I tried it out and it was really simple to do!
this place rocks

np - as indicated by the two sites, the Fll Hande has a number of uses. Thanks for your respnse.
---