How To Lock Cells

Z

Ziggy M

I was just wondering how can i lock cells so a formula cannot be eddited
or how do i lock cells so any of the information cannot be edited as
well.

Please and thanks
 
D

Dave Peterson

format|cells|protection tab|check locked

But this works in conjunction with:
tools|protection|protect sheet

(and this protection is easily broken.)
 
G

gameguru365

Just highlight the cell(s) you wish to lock, then right click on those cells
and go to Format Cells. From there, go to the "Protection" tab. You can
choose how you want to protect the cell. Once you have finished that, you
must then protect the entire sheet - go to Tools > Protection > Protect Sheet.

That should do it =)
 
Top