Block cells for updating

I have a worksheet with figures and fumulas. I want to block the formula cells for updating. Calculated Figures on these cells shold be visible as we need them to see.
Also, it is better if the sheet is not password protected. How can i do this?

Almir's picture

Protect cells with "Hidden" attribute on for hiding formulas

If you want to protect cells from updating, you need to protect cells with "Locked" checkbox on. For hiding formulae (but still calculating the result), check the "Hidden" box on. Finally, you have to protect the sheet, in order cell protection to take effect.