Forum menu
excel help how to l...
 

[Closed] excel help how to lock cells

Posts: 1925
Free Member
Topic starter
 

Probably very simple but how do i go about locking cells in a spreadsheet that have formulas in i don;t want others to change

ta


 
Posted : 13/07/2012 9:25 am
Posts: 3729
Free Member
 

The "protect sheet" function will allow you to define what cells you want to protect with a password whilst allowing changes to others.

Edit: actually you have to select the cells that you want to lock first which you can do under the "Format Cells" sub menu.


 
Posted : 13/07/2012 9:33 am