Ask Your Question

how to protect only certain cells

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

No1MrED gravatar image

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

edit retag flag offensive close merge delete


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

fcosta gravatar imagefcosta ( 2020-01-27 11:08:40 +0200 )edit

2 Answers

Sort by » oldest newest most voted

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

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

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 3,660 times

Last updated: Dec 06 '17