how to protect only certain cells

Need to prevent changes to formula cells, only allow input in a few cells

The answers seem very comprehensive to me.
Shouldn’t this question be closed?

Hello @No1MrED,

Cell protection is only effective after the sheet has been protected.

  1. Right-click inside a cell that must be protected, and select the menuitem “Format Cells…”;
  2. In the dialog that pops up, select the tab “Cell Protection”;
  3. Under “Protection”, check the checkbox “Protected”;
  4. Click OK;
  5. Now Select the menu “Tools : Protect Sheet”;
  6. In the dialog that pops up, check the checkbox “Protect this sheet and the contents of protected cells”;
  7. Set password and further settings as desired, and click OK.

HTH, lib

Note that when you create a new spreadsheet the default setting for all cells is protected. So right click in the cells you want to be available for input and on the “Cell Protection” Tab uncheck “Protected”.

Thank you. This is the confounding part for me. I spent hours protecting cells and then the sheet to find I couldn’t edit unprotected cells. This info should be part of the original answer. In order to protect some cells one must use the backwards action of unprotecting the cells available for editing.