Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion

Locked

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