Home » Forums » Open Source Learning Center » Question and Answer

Block cells for updating

Submitted by ulsk on 13 March, 2014 - 08:09

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?

‹ Hystogram in Excel Data Swap ›
»
Almir's picture

Protect cells with "Hidden" attribute on for hiding formulas

Submitted by Almir on 17 March, 2014 - 08:39.

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.

»