General discussion


Excel formulas

By rstevensl ·
I just want to protect formulas in a spreadsheet to avoid someone from knocking out the formula or deleting the formula. When I used format-protect sheet it locks up the entire sheet,and I can neither input or edit. All I want to be protected is the formulas.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by j.lupo In reply to Excel formulas

Not sure what version you are using, but you can also protect cells in a sheet. Highlight the cells you want protected. Make sure they are marked as protected. Make sure all other cells are unlocked, then protect the whole worksheet.

Related Discussions

Related Forums