Excel Issues

jamie110977 · 09-13-2002, 04:56 PM

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

**Pseudocyber** · 09-14-2002, 08:20 AM

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.

09-13-2002, 04:56 PM	#1 (permalink)
jamie110977 Registered User Join Date: Sep 2002 Posts: 1 OS: win98	Excel Issues 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 A1B1 A1C1 2 A2B2 A2B2 3 4 ETC>>>> Please help

09-14-2002, 08:20 AM	#2 (permalink)
Pseudocyber NetEngr/Geek Join Date: Sep 2002 Location: Earth\US\NC\Charlotte Posts: 1,394 OS: Win2K	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.