Hi Dennis
Try this =C10*E$4 or =C10*$E$4
First one locks the row# and the second one locks both Row and Column.
Type "Relative" in the Help window.
HTH
John
"Dennis Gelso" wrote in message
news
e4=1.075
=c10*e4
=c11*e5 ( should be e4)
=c12*e6 (should be e4)
=c13*e7 (should be e4)
I want to copy the 1st formula and pull down the c11 to c20 but keep
the row number to stay the same (e4). I don't want e5 or e6. Iknow
there is a way to stop
e4 from Incrementing row numbers
--
Dennis Gelso