How to block cells contains formula in excel?



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