Put a dollar sign in front of the constituents of the fixed cell. For
example, in a simple fractional equation
=A2/$B$23
The contents of cell B23 will always be the divisor as the equation is
copied to other cells.
GeorgeF


--
GeorgeF
------------------------------------------------------------------------
GeorgeF's Profile: http://www.excelforum.com/member.php...o&userid=24124
View this thread: http://www.excelforum.com/showthread...hreadid=400847