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


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 20:58:31 -0400, littleps
wrote:


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

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

TIA