copy same formula

L

littleps

Hi,
I've got numbers in columns A & B. Let's say cells in column C contai
simple formulas =A1*B1, etc. How do I make a copy of cells in column
from column C with the same formulas i.e. =A1*B1, etc.? In other words
want to leave original formulas in column C and have the same in colum
D.

Perhaps, it's simple. Just can't get the right thing by doing a simpl
copy operation.

TI
 
G

Gord Dibben

Might be easiest to enter =A1*B1 in D1 and double-click on the fill handle of D1


Gord Dibben MS Excel MVP
 
L

littleps

Gord,

What if formulas in Column C are mixture of referenced cells fro
various sheets? Can't do type everything manually, or cell by cel
copying cell contents...

Tks
 
G

Gord Dibben

In that case I would select column C range of formulas and Edit>Replace.

What: =

With: XXXX

Replace all.

Copy Column C to Column D then reverse the Edit>Replace process with both
columns selected.


Gord
 
Top