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