Locking Excel formulas. How and why we do it?

Locking Excel formulas. How and why we do it?

Why do we need this? Did you have a situation where you painstakingly constructed a formula, that was working well and good.Only to find out that your boss wants you to insert a few rows here and there. Aaaargh. Pain in the butt. When I was new to Excel I had to...