[jamie110977]

I need to know how to copy a formula over in excel. I have a HUGE data base and cannot figure it out.
I have a simple formula that I am trying to copy over

I need to take a cell that will always stay the same * another cell that will change in the Colums. but the first cell will always be the same.

EXAMPLE:

A B C D E
1 A1*B1 A1*C1

2 A2*B2 A2*B2

3

4

ETC>>>>
Please help



:upset:

 

[Pseudocyber]

Select the range you want to copy the formula into. Make sure the first cell is the one with the formula.

Select Edit/Fill Down. I use Ctrl+D for short.