Hi,
Highlight your sheet, press CTRL + H, find what enter =E13, replace with
enter =$E$13

"Bishop" wrote:

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?