I have worksheet with several hundred formulas in the form of =E13. I want
to make all the formulas static, i.e. =$E$13, because I have to delete some
rows and I don't want the formulas to automatically update to accomodate the
missing rows. Is there a way to do this in one fell swoop rather than
having to change them all manually?