excel help how to l...
 

MegaSack DRAW - This year's winner is user - rgwb
We will be in touch

[Closed] excel help how to lock cells

1 Posts
2 Users
0 Reactions
38 Views
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 8: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 8:33 am