Software

Ask something
Discussion Locked

Excel formulas

0 helpful
1 reply

by rstevensl

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

1 reply

by j.lupo

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.

This discussion is closed to new replies.