Just fix the column ref ("E") in "E2" with a dollar sign ($)
Amend the formula in F2 to: =$E2+F1
Then copy F2 to G2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"zuri125" wrote in
message ...

I am trying to find a way to "fill in" a funtion.
I have F2=E2+F1, for example. I want the cell next to it, G2, to be
=E2+G1. In other words, I want Row 2 to be the addition of E2 to each
cell in Row 1. however, when i "fill in", G2 becomes =F2+G1.
How do I make E2 a constant in the formula?


--
zuri125
------------------------------------------------------------------------
zuri125's Profile:
http://www.excelforum.com/member.php...o&userid=31131
View this thread: http://www.excelforum.com/showthread...hreadid=507968