Ask Your Question

how to protect only certain cells

asked 2017-12-06 00:59:12 +0100

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-12-06 15:37:52 +0100

peterwt gravatar image

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".

edit flag offensive delete link more

answered 2017-12-06 02:46:59 +0100

librebel gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-06 00:59:12 +0100

Seen: 30 times

Last updated: Dec 06 '17