Use this:

=$E2+F$1

Biff

"zuri125" wrote in
message ...

ok, thanks you for that.
But, the $ only works for rows.

I have F2=E2+F1, for example. I want the cell below it, F3, to be
=E3+F1. In other words, I want Column F to be the addition of F1 to
each cell in Column E. however, when i "fill in", F3 becomes =E3+F2.
How do I make F1 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