In the cell with the absolute formula, repeatedly press F4 until all the dollar signs are removed from the reference.