Can't seem to find this tip, probably calling it the wrong name. Want
to copy a formula (x/y) from cell to cell, but keep the denominator (y)
pointed at the same cell each time.


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

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

You da man, GeorgeF. Thanks


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

Try this:
x/$y

You can also click on the formula and press the F4 key. Keek hitting F4 to
toggle through all options.


"DQ1" wrote:


Can't seem to find this tip, probably calling it the wrong name. Want
to copy a formula (x/y) from cell to cell, but keep the denominator (y)
pointed at the same cell each time.


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