Ask Your Question

Lock a Calc Range having a formula

asked 2018-09-19 11:10:53 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Is there way to lock the entire column or range containing a formula to protect it?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-09-20 22:30:37 +0200

erAck gravatar image

Select the cells that are not to be protected and go to menu Format -> Cells, tab Cell Protection, uncheck Protected, OK. Then menu Tools -> Protect Sheet, and either enter a password or leave password empty, OK.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-19 11:10:53 +0200

Seen: 52 times

Last updated: Sep 20 '18