Tech Support banner

Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter #1
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

:confused:

:upset:
 

·
Registered
Joined
·
1,393 Posts
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.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top