Lock some cells in Excel

Tweet

I have learn a way to lock some cell in Excel. It's help us protect some formula cells in excel. User can not view the formula or edit these cells, They just see the result of this formula. This is how to do that, hope this tips helpful for you. Step 1: - Select all cells in your worksheet then go to menu: Format-cell, select "Protection" tab, unchecked on "locked" check box. Step 2: Select cells you want to locked (in this case is "total" column, then go to Format-cell, select "Protection tab, check on "locked" check box. Step 3 - Go to menu: Tool-protection-protected worksheet + Unchecked on "select unlocked cell" + Type your password in the text box. + Then click OK to submit. (Pic 3) + Type password again to confirm. - Now your cells is protected with password. You can't view or edit formula on those cells. - If you want to unlocked these cells, go to menu : Tool-protection-unprotected worksheet! Type the password when prompt.