Protecting spreadsheets

Hi Tony,
Welcome to the forum, and thank you for your post;

In order for a cell to be protected - The worksheet must be protected and the "Locked" checkbox on the (Format > Cells)(Protection tab) must also be checked. (This is the default).(Format > Cells)(Protection tab)

If you only want to protect a few cells - first remove the locked property from all the cells. Select (Ctrl + "A") and clear the locked check box. This will mean that even if the worksheet is protected the cells will not be. Select the individual cells that contain formulas you want to protect and change the property back to Locked.

If you want to protect a few formulas without protecting the whole sheet select the cells and choose (Data>Validation), Select custom in the first window and type (="") in the second window.
I hope that has helped, regards Pete