Hi Guys,
How do I lock cells in an excel spreadsheet so no one can change the formula or the contents of that cell?
Thanks!
R
Hi Guys,
How do I lock cells in an excel spreadsheet so no one can change the formula or the contents of that cell?
Thanks!
R
Hi,
Select the cells or the entire sheet.
Right click the selected area.
Select Format Cell.
Click on last tab (Protection). Make Sure that Locked Check Box is checked.
Now, Click on Tool --> Protection --> Protect sheet and put password....
Now no body will be able to see the formula.
Shijesh Kumar
http://shijesh.wordpress.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks