My stepdad is using a really old version of Excel. He would like to allow his
church secretary to input data but not delete formulas. (He has his formulas
typed into the same cells she would change). So is there a way to
protect/lock these cells, so that the formulas stay intact? I have read many
posts about locking and protecting, so we understand all that, but doesn't
seem to take care of his problem. He doesn't want to lock the cells, because
then she can't input numbers. Is the only answer to type formulas in a
different cell that references the cell that she types into?