Using microsoft excel how do you insert a formula for multiple cells at once?

Im using microsoft office excel 2007 if that helps

Using microsoft excel how do you insert a formula for multiple cells at once?norton antivirus 2007

After you enter the formula in the cell, you should be able to move your cursor to the bottom right of that cell, and click and drag. This will copy the formula along, and also try to dynamically adjust your formula's in case variable cells change.

Visit http://www.thetechjuice.com for more technology news, tips, tricks, and how-to's.

Using microsoft excel how do you insert a formula for multiple cells at once?product key

higlight the cels you want to have the formulas in and then type your formula in at the top formula bar...only do the cells you want though!!
in the cell you want the answer type equal sign (=) then the cells you want to addd subtract or what ever.

Example:

=A2+B2+C3+D5

then just click out if the box and it preforms the formula