Many times we require to protect cell which contains the formulas in a excel
So calculation will be good and anyone can use that workbook
Following are basic steps to protect cells in excel
Step 1 : Select all cells in a sheet by Ctrl + A
Step 2 : Press Ctrl + 1 -> Goto Protection and uncheck "Locked"
Step 3 : Press F5 -> go to special -> select redio button of formulas and click on ok
Step 4 : Press again Ctrl + 1 -> Protection -> check "Locked"
Step 5 : From the menu go to Tools -> Protection -> Protect Sheet -> Type Password -> OK
its Done
Comments
Post a Comment